1 of 1 people found this helpful
How's this for you?
All I've done is create the IF <5 on the aggregate, and not Row Level (notice the SUM wrapper)
[Rating 15 - 19 (to use)]
IIF(SUM([Rating 15 - 19])>=5, SUM([Rating 15 - 19]), NULL)
As the SUM is calculated at the vizLoD (Viz Level of Detail), which in this case is Colour/Rating that is the level the >= 5 test is applied.
Hope that helps.
I feel so silly for not thinking of that. Thank you Simon!
Done it myself many (many, many) times!...sometimes you are just too close to a problem! (...I once created some complicated, nested, table calculation type logic, having worked through a problem step by step. I showed my college (such was my pride)...only for him to notice "isn't that just SUM([Number of Records])"...Doh!!!)
Hello Simon Runc,
Glad to run into you again. I want to show "s" when cell sizes are <= 5 and "--" when the data are actually missing rather than the NULL option above. I am playing with having the data come in from Excel already formatted this way vs. doing it within Tableau.
With the former, all of the Measures are now coming in as Dimensions due to the "s" and "--" values in the columns.
With the later, I am not having luck finding the right community posts on creating the "s" or "--" based on the value of unweighted_N.
Appreciate you pointing me in the right direction!
Nice to hear from you again. So if I understand correctly this should help. I have broken it down into 2 steps (as I don't know if the "missing" data is actually in the dataset, and just equated to NULL, or doesn't exist so we want "create" the NULLs
I've created the following calculated field...
[Height - S if <12]
IF SUM([Height])<12 THEN 'S'
ELSEIF ISNULL(SUM([Height])) THEN '--'
using the STR() (string return) so I can have both numbers and strings in the same field.
In this example we don't have any NULLs in the data (eg. from the below image, ID=25 and Color = "Blue" just doesn't exist
However if you look at the "S and NULLs" tab, I have added an index() calculation to the detail tile
When we have 2 opposing blue pills (as we have here, on the rows and columns) and a table calculation (which index() is) Tableau "densifies" the data, so creates marks for every possible combination
Hope that's what you were after, but let me know if not
Appreciate the guidance. We will give it a try and report back.