Avg line on graph & change color when it goes below

[mandilicious]

Hi Champs

I have below graph and SLA within is 85% so they need to see line move horizontally from 85% on a graph  and if it goes below 85% it suppose to be red in color.

Thanks

[stabben23]

Hi,

click on the + sing on Your Expression. Use Backgroud color, copy and past Your Expression in here, add an if statment like:

if(Your copied Expression)<0.85, red())

[stabben23]

Or do you want a New Reference line in the same chart?

[mandilicious]

Hi Staffan

Yes please that will also help and if i may ask how do i draw/put line that will start from 85% going from right on graph?

Below is my exp.

=num((count({$<campaign_id={"neo_za_en_service","neo_za_en_tech"},user_group={"NEO"},queue_seconds={"<=20"}>}phone_number)

-  count({$<campaign_id={"neo_za_en_tech","neo_za_en_service"},user_group ={"ABANDON"},queue_seconds={"<=20"}>}lead_id)

+ count({$<campaign_id={"neo_za_en_tech","neo_za_en_service"},user_group ={"ABANDON"},queue_seconds={"<=20"}>}lead_id)/100)

/  count({$<campaign_id={"neo_za_en_service","neo_za_en_tech"},user_group  ={"NEO"}>}phone_number),'##.%')

[stabben23 · Accepted solution]

Hi,

create a Reference line->Definition With Expression:

count({$<campaign_id={"neo_za_en_service","neo_za_en_tech"},user_group={"NEO"},queue_seconds={"<=20"}>}phone_number)

-  count({$<campaign_id={"neo_za_en_tech","neo_za_en_service"},user_group ={"ABANDON"},queue_seconds={"<=20"}>}lead_id)

+ count({$<campaign_id={"neo_za_en_tech","neo_za_en_service"},user_group ={"ABANDON"},queue_seconds={"<=20"}>}lead_id)/100)

/  count({$<campaign_id={"neo_za_en_service","neo_za_en_tech"},user_group  ={"NEO"}>}phone_number))

then use Line Formatting->Color->Calculated, this expression

if(count({$<campaign_id={"neo_za_en_service","neo_za_en_tech"},user_group={"NEO"},queue_seconds={"<=20"}>}phone_number)

-  count({$<campaign_id={"neo_za_en_tech","neo_za_en_service"},user_group ={"ABANDON"},queue_seconds={"<=20"}>}lead_id)

+ count({$<campaign_id={"neo_za_en_tech","neo_za_en_service"},user_group ={"ABANDON"},queue_seconds={"<=20"}>}lead_id)/100)

/  count({$<campaign_id={"neo_za_en_service","neo_za_en_tech"},user_group  ={"NEO"}>}phone_number))<0.85, red(),green())

You could also hide and show reference line by adding a show condition, use the same Expression as in color, but change color code Red, green against 1,0

[stabben23]

if you just want a static line, use a second line Expression 0.85

[mandilicious]

Thanks Staffan you are the best it is working perfectly.