Is it possible to get the excel or twbx file.
Your screenshot doesn't include any NULLs, it only includes numbers. Are you trying to get rid of the zeros?
Yea this is just an example, It is Null values. I can't show the real data or real sheet from tableau because of privacy. Imagine the original picture but without data where there are 0's.
Does this help?
Thanks so much
I don't have a data set with nulls readily available to test this theory...
But can this calculation work...then just place on the filter shelf and exclude 1?
(IF ISNULL([Measure1]) THEN 1 ELSE 0 END) + (IF ISNULL([Measure2]) THEN 1 ELSE 0 END)
So i have 16 different measures and it just came back with the number 15. When I made it a dimension it said 15 or 15 for the filter. I looked to see how many it was counting for nulls and it wasn't the same number of nulls that I had in my csv. I am wondering if I could try do something were I make all the null values 0 in my csv and then have an if statement that counts if its equal to 0.
(IF [measure1]= 0 THEN 1 ELSE [measure 1] END) + (IF [Measure2] = 0 THEN 1 ELSE [Measure 2] END)
Then just place on the filter and exclude 1.
I'll try this..
Hmm, the above solution suggested by Daniel should work. Is it possible that it's not actually null and there is perhaps a space in some of the supposedly "null" cells in your Excel sheet? If you use the equation you are suggesting, it would (theoretically) return the exact same result.
Maybe it would be something like this...
IF ((IF ISNULL(SUM([Measure1])) THEN 1 ELSE 0 END) + (IF ISNULL(SUM([Measure2])) THEN 1 ELSE 0 END) +....) > 0 THEN 'Hide'
I'm a little confused by this one, can you explain?
On Wednesday, October 7, 2015, Daniel Vincent <
You can either use my original calc or the new one. With the new one I'm explicitly asking if the sum of all values is > 0 (not null) as you would filter for only the 'Show'
The original probably needs some adjustment as it needs to aggregate the measures i.e. ISNULL(SUM([Measure1])) Once you have a calc with all the possible measures that could have a null then you will get a sum of something > 0. Then you just filter out with a At Most like this:
Either idea should in theory work. If you could post a sample workbook that has a small data set anonymized that would help us trouble shoot/come up with a solution. Anonymize your Tableau Package Data for Sharin
Hmm..still cant get it work. But I think the whole problem is the + it is adding everything up as I filter between companies. Can I use an OR statement??
I changed my Null's to zero's and wrote this..
Its close, but as I filter by company it doesn't work. So now I am thinking I have to add something in the formula that also looks at the company name. Not sure how to do that...
Anybody have any ideas??
Bump, still can't get this one.