Color declaration in Pivot cells

[krishna20]

Hi Folks,

I am  having a pivot table and having a dimension as time interval.

I need to write a background color expression like when time interval is <= 00:15:00 ,green() and >00:15:00,Red().

I tried like below it's directly taking the else condition,can anyone advise me what is the issue and proper solution.

Background color expression:

if($(vACD_Agent_NotReadyDuration)<='00:15:00',RGB(102,255,102),

if($(vACD_Agent_NotReadyDuration)>'00:15:00',RGB(255,121,121)))

Thanks

Krishna

[kaushiknsolanki]

Hi,

Try this.

if($(vACD_Agent_NotReadyDuration)<=Maketime(00,15,00),RGB(102,255,102),

if($(vACD_Agent_NotReadyDuration)>Maketime(00,15,00),RGB(255,121,121)))

Regards,

Kaushik Solanki

[krishna20]

Hi Kaushik,

Thanks for your reply. No change.

[kaushiknsolanki]

Hi,

Can you tell us what value your variable has and how are you assigning value to variable.

Regards,

Kaushik Solanki

[krishna20]

variable is storing the below expression .

interval((sum({<eventtype={'2'}>}EventDuration))/86400,'hh:mm:ss')

[krishna20]

Hi,

Can anyone advise me on this??

[kaushiknsolanki]

Hi,

Can you share sample data.

Regards,

Kaushik Solanki

[rubenmarin]

Hi Kalyan, it seems ok, just ensure that the variable expression doesn't have an starting equal sign, with an equal sign it will evaluate globally and return the same result for all cells.

By the expression, EventDuration should be received in seconds.

In any other case a sample will be nice to see what's happening.

[Anil_Babu_Samineni]

Is this return $(vACD_Agent_NotReadyDuration) for data points?

[krishna20]

Hi All,

Issue resolved. That was a self variable mistake in the background expression. Thanks to all for your valuable suggestions.