Problem with a color expression

[mtabernad]

Hi everyone,

I am using this expression as KPI, which is the std deviation of number of connections over the daily average:

(count({$<date_id={"$(=max(date_id))"}>}connect_time) - (count({$<date_id=>}connect_time)/count(distinct {$<date_id=>}date_id)))

/

(count({$<date_id=>}connect_time)/count(distinct {$<date_id=>}date_id))

also I built a bar chart to see this deviation by user with the following color expression:

if(((count({$<date_id={"$(=max(date_id))"}>}connect_time) - (count({$<date_id=>}connect_time)/count(distinct date_id)))
/
(count({$<date_id=>}connect_time)/count(distinct date_id)))<=0.50,Green(),rgb(255,31,31))

KPI expression and color expression work for maximum date (in my case 31/10/2019)

But if I pick the previous day on the date filter panel (30/10/2019) or other days, KPI expression still works but color expression doesn't:

Could anyone help me?

Thank you very much.

[hallquist_nate · Accepted solution]

Your expression for the KPI is not matching your expression for the color definition.  You are missing sthe set expresions is formula segments as show below in the pic.

This is always a tricky excercise for me.  I reduce risk by copying and pasting my KPI formula into my If() statement.

Hope this helps,

Nate

[mtabernad]

Ohhh! You were sooo right! I don't know why I didn't realize about it. Thank you very much!