Is it possible to drill into a calendar while using a Year View by MONTH rather than Day?
Best Answer
Answers
-
Based on the card type, the month is not clickable. Therefore it is not drillable. The individual date is what is sent and so if you clear the filter it will show you the month view, which is what I believe you are looking for.
However a work around is to create a Month Year column and then use the Page Analyzer. You can then select the Month/ Year combo you want to view and it will change it to a month view, based on the data select. As long is it is set to Auto in the view prefence.
Steps to reproduce:
First you need supporting data:
In MySQL you can use something like this in your DataFlow:
concat(monthname(a.`date`), ' ' ,year(a.`date`)) as 'MonthYear Name'
In Magic ETL
you can add a Date Operations, Value Mapper, and then a Combine Columns actions and you can get the same results.
Once you have the data, Edit your card as follows:
Set the view preferences to Auto, like below:
Now when you view the page you can enable the feature by following these steps:
This is image below shows clicking on the Page Analyzer (the blue filter), with the option of the MonthName column.
After you select an option you see it filters down below:
Good Luck!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive