How to erase future cumulative bar lines on line + bar chart

I found this post - but it didn't work for me when filtering on Historical. Specifically, I created a beast mode as such:
CASE
WHEN Type
='Goal'then 'Historical'
When Type
='Renewal' and Actual_Date_Closed__c
<= LAST_DAY(DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)) and Type
='Renewal' THEN 'Historical'
ELSE 'Future'
END
I was hoping the results would remove this portion of the bar chart, which are future months of the year. I could get it to work on other bar charts, but not this line + bar chart, which makes me wonder if this is possible.
Answers
-
It looks like I was the one who answered it in the post you referenced. What you need to do is when you are testing to see if the date is for the future then you need to use a value of zero or blank. It looks like you are just placing a label of "Future" when it is a future date. That won't change the value.
If that doesn't make sense, if you can send a screenshot of Analyzer and what is in the x-axis, y-axis and series, I might be able to come up with a more exact beast mode for you.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 98 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive