Histogram Represent Y axis as %

Viswaja

I am using histogram card to show the distribution of users in a percentile.

Currently the Y axis is using count of users and the graph is showing user count in a percentile.

I would like to change this to a user % and would like to show % of users in a percentile.

So for example 2% to 7% should show % of users ( 50 / total count of users) and the vertical axis should be out of 100

GrantSmith

Currently the Histogram graph doesn't support this. You could attempt to define your own categories/buckets within a beast mode and use that as your x-axis on a standard bar chart and another beast mode to calculate the overall percentage.

GrantSmith

Currently the Histogram graph doesn't support this. You could attempt to define your own categories/buckets within a beast mode and use that as your x-axis on a standard bar chart and another beast mode to calculate the overall percentage.

Viswaja

Thank you. I have created 5 buckets and I am not sure why only the last bucket is showing on a bar chart. I can see more buckets in the underlying data. Any insight on this?

For reference I am using a case statement to create my buckets. Something like this.

CASE WHEN
(SUM(min(1)) over (partition by cat1,cat2 order by sum(value) asc)
/
sum(min(1)) over (partition by cat1,cat2 )) > 0

AND

(SUM(min(1)) over (partition by cat1,cat2 order by sum(value) asc)
/
sum(min(1)) over (partition by cat1,cat2 )) <= 0.25 THEN '0% - 25%'