-
1. Re: How to exclude zero values in filter?
Deepak RaiSep 25, 2017 11:00 AM (in response to Derek Thomas)
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?
Derek Thomas Sep 25, 2017 11:23 AM (in response to Deepak Rai) -
3. Re: How to exclude zero values in filter?
Deepak RaiSep 25, 2017 11:33 AM (in response to Derek Thomas)
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?
Derek Thomas Sep 25, 2017 12:31 PM (in response to Deepak Rai)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?
Derek Thomas Sep 25, 2017 12:32 PM (in response to Derek Thomas) -
6. Re: How to exclude zero values in filter?
Deepak RaiSep 25, 2017 12:35 PM (in response to Derek Thomas)
Derek, Please share a workbook with mock data
-
7. Re: How to exclude zero values in filter?
Derek Thomas Sep 25, 2017 12:42 PM (in response to Deepak Rai)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?
Jayshree Dawrewar Sep 25, 2017 11:01 PM (in response to Derek Thomas)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
-
9. Re: How to exclude zero values in filter?
Derek Thomas Sep 26, 2017 6:04 AM (in response to Jayshree Dawrewar)THANKS A MILLION!
-
10. Re: How to exclude zero values in filter?
Jayshree Dawrewar Sep 26, 2017 6:10 AM (in response to Derek Thomas)Your Welcome!
if that helped you could you please mark it as answered.
Thanks!