Histogram Buckets Beast Mode

Viswaja

 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%'

MichelleH

@Viswaja Do you have any fields in the Sorting section of Analyzer?

Viswaja

No. I can see the underlying table has buckets assigned. I am not sure why the bar graph is only defaulting to the last bucket