Hi, i am looking to build a histogram in a view with a KPI which gives a throughput time between 2 activities. I need the frequency of cases on Y axis, and a (automatic) grouping/bucketing of the KPI values on the x axis.

I have tried to use the Histogram option in the View, but it seems not to accept KPI's (only data value columns). So i created a Record (attribute) in the activity table with the same formula as the KPI and use that as attribute in Histogram instead. But i get an Error: "Aggregate expressions cannot be nested inside aggregate expressions."

Is there any other way of producing the desired result? I can use a normal chart but it will not do the buckting automatically and i don't know how or where to create an extra buckting table.

Thanks in advance

Himanshu