"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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有