Forum Discussion
Removing 0's from Line and Clustered Column Chart when relative date is set to last 13 months
Hi All,
I was wondering if someone could help, I have a Line and Clustered column chart and I have put the date filter type as the below -
The problem I have is when I look at my graph it filters all the dates needed and the data looks fine for all the last 13 months although the issue I have is it still leaves a trail line of 0's front and back of the dates due to my date table.
I have tried many ways to filter my columns with an example being Open tickets IS NOT 0 and it removes some of my data..
I am hoping someone can direct me in a way to look into how to remove 0's from a bar graph when the relative date is filtered.
Thanks all
2 Replies
- parry2k
Super User
DataLife321 if you are adding zero to the measure you will get exactly the result you are seeing, the best way is to read/watch thru this post and update your measures accordingly.
- DataLife321Frequent Visitor
Thank you for the response yes I had a few measures with +0 at the end..
I have since removed them and it works .. thank you