"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
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 483 APIs & Domo Developer
- 88 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive