Displaying Empty Buckets on the Bar Chart Legend

heathqm — Mon, 28 Feb 2022 19:23:26 GMT

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.

Re: Displaying Empty Buckets on the Bar Chart Legend

Digvijay_Singh — Tue, 01 Mar 2022 04:11:25 GMT

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)

topic Displaying Empty Buckets on the Bar Chart Legend in App Development

Displaying Empty Buckets on the Bar Chart Legend

Re: Displaying Empty Buckets on the Bar Chart Legend