I have an output that looks like the one in picture attached. The measures are based on a calculated field which represent a count of non zero values per market: SUM(IF [Cost] <> 0 THEN 1 ELSE 0 END)
I would like to create a histogram for those values. The way I would like to present is to have number of market with the mesure between 0-3, then number of markets with the measure between 4-6 and so on.
I read about the histogram in Tableu help and it requires bins creation but this option is unavailable for the measure I am using.
Does anyone have any suggestions how the data should be structured so I can create the output that is needed?