Drilldown from Gauge Card to YTD Month Grouped Bar
I am working with my company's financial data in Domo to build an executive dashboard which will show, amongst other things, information about actual revenue vs budgeted revenue year to date.
I have built a card in which the sum of the rows for actual revenue is the gague value, and the budgeted revenue is the actual value. If actual revenue is >= budgeted revenue, this shows 100%. This card itself is fine. Each property that my company does business with has its own gauge card which I want to use for the drilldown.
Now that I am trying to build a drilldown I am encountering issues.
The issue is that the date picker does not allow me to create a grouped bar card that shows the the YTD actual and budget values partitioned by month. The data view from within the analyzer shows the same date column, but I cannot select 'Graph By Month' in the analyzer.
In the analyzer it shows the data for All Time, but correctly displays only the data YTD in the card view.
Is there any way that I can drilldown from a gauge card to a grouped bar with data graphed by month?
Comments
-
Not a perfect solution but this should work
On the drill card create a beast mode "Month" (in your prefered format) and use that as your X axis.
Unfortunately with that you wont be able to change the date grain in the drill card
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive