Running Total Group Bar - keep running total but in a specific range of time
Hi all,
I have this case that is similar to the #52547 discussion and I quote. The difference here is that I need to be able to select any portion of time that the user needs, for example, a specific year (graph by month or quarter or... )
Also, it may be able to filter by other columns. See the image attached.
If I select only the last two months, I need to be shown the same values.
I'm using beast mode:
`sum(sum(value)) over (partition `Business Unit`, `Customer Segment` order by Date)` but when I filter only the range I need the previous months is lost, as I expected. Is there any way to do this?
Any help will be very appreciated.
Thanks in advance
Best Answer
-
One option is to leverage the zoom capabilities, where you click and drag your mouse around the months you want to zoom into, such as the last two months. You can even start it zoomed in when you are in Analyzer, and then the user can click the arrow to zoom back out. This should keep your running totals in tact. I could see how using the date rang filter would alter the calculations.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Thank you so much for your response, Mark. It was really helpful. And I'm so sorry for my late reply.
1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有