topic Problem with a color expression in App Development

Problem with a color expression

mtabernad — Sat, 16 Nov 2024 04:02:46 GMT

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.

Re: Problem with a color expression

hallquist_nate — Fri, 22 Nov 2019 15:43:38 GMT

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

Re: Problem with a color expression

mtabernad — Mon, 25 Nov 2019 09:28:19 GMT

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