AGGR Function - how to use in this case

[avastani]

What expression would I use to remove the Region dimension and maintain the month-year and create a stack bar chart showing number of distinct Regions with Utilization in 3 custom buckets of <.75, .75<=x<0.9, >=0.9?

I tried the Aggr function and it does not display anything.

i tried

sum

(if(aggr($(veUtilization), Region, Country, [World Region],_MonthYear) < 0.75, 1, null())) and the similar for other buckets but it does not give the right results

no worries, i figured it out. I had Country and pWorld Region dimensions that did not belong in there. Interesting how the aggr function worked when i had it in there.

[#2]

You don't nedd AGGR, just add a new dimension :

=if(V>0.9, 1 ,
If(V>0.75 , 2 , 3))

Expression : = count( distinct Region)

Don't forget to check Stacked Bar

Here an example

jjj

[avastani]

Interesting when I try your solution it doesn't work for me since it gives a message error in calculation for expression.

[#4]

maybe problem with the comma ',' or the dot '.' .

Check your decimal setting.

JJJ