"Older" or "Newer" bucket
Hello,
I often have requests to see data by time periods. And for this the grouping feature by day, week, month, quarter, year is great. However in a lot of cases, you do not want to see the whole granularity of the distribution: i.e. you want to see bucket like: "Older than 12months", "12m to 6m", "6m to 3m" and younger.
It is fairly easy to answer this with a grouping by quarter, which also lets the end user change the granularity on demand. BUT when doing this, either you filter for data younger than 12m, but your total does not match the sum of the bar on the screen, or you display everything and the data that you are interested in (current year) is swallowed in a potentially very long tail that you are not very interested in.
I have worked around this with Beast mode and date functions, but I lose the abiliity to change the granularity on the fly...
Anyone managed to find a better solution?
Comments
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive