-
1. Re: Determining if all values are the same
Jonathan DrummeyJan 31, 2012 12:41 PM (in response to David Drees)
I created a table calc that returns a value of 0 when all products are Inactive, 1 when all products are Active, and an inbetween number for other values, then a second Show/Hide Text calculated field that returns "Hide" for values of 0 or 1 and "Show" for everything else. Putting that on the the Filter shelf allows you to filter. Tableau is a little picky about returning numbers from table calcs, which is why this required two calculations. See attached for details.
-
2. Re: Determining if all values are the same
Jonathan DrummeyJan 31, 2012 12:42 PM (in response to Jonathan Drummey)
You'll need to uncompress the .zip file, apparently the new forums are automatically compressing .twbx files?
-
3. Re: Determining if all values are the same
David Drees Feb 2, 2012 7:20 AM (in response to Jonathan Drummey)Jonathan,
Thanks for your reply. I think that is getting me closer. However, while your solution allows me to filter the appropriate rows in theory, when I put the 'Status' dimension in the Text section, it seems to throw the table calculation off. I need to be able to see the results in the table while also filtering the rows. It seems that I can get one or the other, but not both.
Using the workbook that you sent, if you try to drop "Status" on the Text box, you will see what I mean - suddenly, there is overlapping text.
Am I missing something?
-
4. Re: Determining if all values are the same
Jonathan DrummeyFeb 2, 2012 8:28 AM (in response to David Drees)
When you add Status to the view, you are adding another dimension to the query that the table calcs are performing, so more marks are returned and you get overlapping values. However (and this is a good however), the way the data is arranged there is only one Status for each State/Product combination. So putting a calculated field with ATTR([Status]) on the Text shelf lets you get the right colors and lets the filter happen.
Jonathan
-
5. Re: Determining if all values are the same
Shawn Wallwork Feb 2, 2012 8:40 AM (in response to Jonathan Drummey)To not much effect. Most of the ones I'm seeing are the same size as the original file (which is already a zip file.)
-
6. Re: Determining if all values are the same
David Drees Feb 2, 2012 10:21 AM (in response to Jonathan Drummey)That's it! Now, I just need to understand why that works. I'm still trying to get a handle on table calculations. Thanks so much for your help.