"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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 384 Distribute
- 110 Domo Everywhere
- 268 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive