Compare class to average

[isabelleica]

Hello!

I've created a Simple Bar Chart with a dimension using the class function:

=class(Aggr(Sum([Hours]), [Person ID]), 10)

The expression is the amount of people:

=count(DISTINCT [Person ID])

I'm trying to colour the bar where the average of hours per person is found. I can find the average using the formula:

=Avg(Aggr(Sum([Hours]), [Person ID]))

How can I colour the class bar that contains the average?

I'm trying the following formula, but it is not working:

if(

    class(Aggr(Sum([Hours]), [Person ID]), 10)

    =

    class(Avg(Aggr(Sum([Hours]), [Person ID]), 10))

    ,

    Red(),

    Blue()

)

For example, in the image below, I would like to colour the 110-120 bar as Red (since it contains the average) and the others to remain Blue: