Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to display all the buckets created on the bar chart?
Right now I have created buckets like this in the data load editor:
If([Total Program Status Value] <= 0, '0',
If([Total Program Status Value] > 0 and [Total Program Status Value] <=3, '1-3',
If([Total Program Status Value] > 3 and [Total Program Status Value] <=6, '4-6',
If([Total Program Status Value] > 6 and [Total Program Status Value] <=9, '7-9',
If([Total Program Status Value] > 9, '10+'
))))) AS [Bucket]
Then I created a Bar chart with two dimensions Program and Buckets then a measure of Count(DISTINCT{<[Bucket]>} [Program])
Right now, there are currently no 0 buckets the way the data is, so I can't get it to show up on the bar chart.
So I tried to put each bucket in as a separate measure like this: Count(DISTINCT{<[Bucket] = {'0'}>} [Program]) but then the buckets are not selectable on the legend and I am only able to select one Program to filter by instead of the buckets.
I had double checked to make sure 'Suppress 0 values' is not checked.
Any help is appreciated.
Not sure of the solution without having access to data and the app but I use sometimes this below trick to show dimensions with 0 metric values -
Count(DISTINCT{<[Bucket]>} [Program]) + Count({1}0)