How to Color by?

[siddharth_s3]

Hello folks,

I have a distribution chart as follows:

• Y Axis - Activity
• X axis - Resolve %
• Points - Cusomter

I wanted to color each of the data point in 2 colors using color by expression

For each activity (Y axis point), the mean has to be found and anything greater than mean is blue and anything less than mean is red.

How can I achieve this?

My color by expression is not auto resolve. It is as follows:

SUM({<$(vDateFilter),GreaterThanToday={0}>}IncidentCount)

So the color by expression should be something like:

IF(AVG(AGGR(SUM({<$(vDateFilter),GreaterThanToday={0}>}IncidentCount),Customer))
>
SUM({<$(vDateFilter),GreaterThanToday={0}>}IncidentCount)
,RED(),BLUE())

[hacr]

Can you attach an app to work with ?