How to erase future cumulative bar lines
We want to erase the future cumulative bar line in the "Line Bar" graph, as shown in the image.
Could you please tell us how to achieve this ?
Best Answer
-
You could control this by creating a beast mode for your bar values where it checks to see if the date is beyond today and make it zero or blank if it is, otherwise use the value. Something like this:
CASE WHEN `Date` < CURRENT_DATE() THEN `barvaluefield` ELSE '' END
Hope this helps.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Thank you for answering!
We have successfully eliminated the future cumulative bar graph with the script you gave us for a simple graph with one series.
However, it did not work for multiple series.
We would like to know how to solve the problem when the "Number of Running Total Lines" and "Number of Running Total Bars" are set up with more than one as shown in the figure.
Thank you in advance.
0 -
If you want to prevent all lines and bar from showing future dates, you can create a similar beast mode and add it to your filters like this:
- CASE WHEN `Date` < CURRENT_DATE() THEN 'Historical'
- ELSE 'Future'
- END
Drag this beast mode into your filters and filter to Historical. This will keep your chart from showing any future data.
If you want some metrics to show future and not others, then you would need to create a beast mode for each metric like the one I first gave you. If you have 12 out of 15 fields, for example, that you don't want to show future values for, you would need to create 12 different beast modes.
Hope that helps.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thank you for answering!
I'll give it a try!
0
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
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有