Change Line Style if current dimension is current hour

[Anonymous]

My line chart displays the volume of incoming phone calls received at the call center over the hours (00:00 - 23:59) of the current day.  I want to change the line style from the last hour to the current hour (it is now 6:32p so I would like the line from 17:00 - 18:00 to be dashed or something other than a solid)

Dimension: Hour(Incoming_Call_Time)

Expression: Count(Distinct(Call_ID))

I figured the below would work but no luck.  I used ReloadTime() because the data is refreshed every 15 minutes.

     =if(Hour(Incoming_Call_Time)=Hour(ReloadTime()),'<s2>','<s1>')

[MayilVahanan]

Hi

I think, ReloadTime() hour is not match with hour(Incoming_call_Time).

Can you provide a sample for that?

[Anonymous]

I can spend some time tomorrow tossing together a sample.

I tested to make sure ReloadTime() was working by modifying my count expression to only count calls if Hour(Incoming_Call_Time) < Hour(ReloadTime()).  The line chart changed and removed calls originating in the 18th hour (6p)

[marcel_olmo]

Hey Nick, I want to do the same, if one condition is accomplished, change the line style, otherwise not.

Have you found a way to do it?

Regards, Marcel.

[annafuksa1]

Please see attachment and tell me is it help

[marcel_olmo]

Thanks Anna! That was it! Regards, Marcel.