Sumo Card - Dynamic Date Column Headers
I am working on creating a trending P&L type report as a Sumo Card. The report contains year over year and month over month trending information.
One particular section of the report has a 3 month trending section with a seperate column for each month. So for example, if I am looking at the report for February 2017 there will be a column for February 2015, February 2016, and February 2017.
I need to figure out how to make the sumo card headers display these date ranges dynamically - dependant upon the date selected in the filter. I would like to avoid having to name the columns something like "Prior Year 3", "Prior Year 2", etc. as that will be overly confusing when looking at the card.
Is there a way to do this within Domo?
Comments
-
How about something like this
For the February scenario above,
Create a MONTH= Month('Date') beast mode
Select a 3 year time period
Add the date field to top right of a Sumo Pivoting table.
Set the Date grain to month
Set a filter for the MONTH column to February only
It should only display Feb 15, 16 and 17
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 133 Manage
- 130 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive