How to exclude zero values in filter?
Hello,
This filter has six categories, but all of them only include a few of the dimensions. How do I ensure that zero values are excluded?
Many thanks!
-
1. Re: How to exclude zero values in filter?
Deepak Rai
Sep 25, 2017 11:00 AM
You can use Set to exclude 0 and then you can drag that Set to filter and replace the original filter with that.
-
2. Re: How to exclude zero values in filter?
Thank you, Deepak. I've been trying to figure out exactly how to do "use Set to exclude 0", but am not quite sure how to do so.
I tried to create conditional formatting, wherein it would only include values greater than $1, but it doesn't seem to be responding.
-
3. Re: How to exclude zero values in filter?
Deepak Rai
Sep 25, 2017 11:33 AM
Go to your Dimension, Right Click, Create Set, Take out 0 and Keep Others and Drag that Set to Filter. 0 would go away.
-
4. Re: How to exclude zero values in filter?
Ugh, I still don't see anything that resembles "exclude zero and keep others".
Is that perhaps not available on Tableau Public?
-
5. Re: How to exclude zero values in filter?
This is what I see. Like I said earlier, I tried to create a condition for any value over 1, but that didn't seem to work.
-
6. Re: How to exclude zero values in filter?
Deepak Rai
Sep 25, 2017 12:35 PM
Derek, Please share a workbook with mock data
-
7. Re: How to exclude zero values in filter?
I guess I don't know how to do that either. Really sorry.
Here's the link in case you're able to download it.
-
8. Re: How to exclude zero values in filter?
3 of 3 people found this helpfulHi Derek,
I guess you have not given the authority to download the workbook at this loc: Tableau Public
So, if you are trying to remove zeros from your report or visual, what you can do is drag the measure used in filter section
and mark it to show atleast 1 like below:
1. Drag the measure you want (continuous field), then click on All Values
2. then select the range as At least and enter 1 click OK .
After this, you will only see data which has values from minmum 1 and there will be no 0s.
Let me know if this helps!
Regards,
Jayshree Dawrewar
-
-
10. Re: How to exclude zero values in filter?
Your Welcome!
if that helped you could you please mark it as answered.
Thanks!
