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

Options

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.

image.png
Tagged:

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 to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.