Display when Value is beyond limit

[kakani87]

Dear All,

When i'm trying to display total time spent in hrs with a specific colour as the above chart in the image shared when greater than 8 hrs.

can any one help me to acheive this.

[tresesco]

Could you share your sample qvw?

[YoussefBelloum]

Hi,

try to extract the hour from your TIME field and do this:

if( Hour([time spent] > 9, yellow(), green() )

[Anil_Babu_Samineni]

What is the measure?

[kakani87]

Hi Tresesco,

PFA.

[tresesco · Accepted solution]

Try:

if(hour([Time Spent])>8,Yellow(),Green())

[kakani87]

Thank you Tresesco.