Forum Discussion

Jim123456789jim's avatar
Jim123456789jim
Frequent Visitor
8 years ago

Bar Graph colour based on Y axis value

Hi All,

 

I have a Bar Graph in which the X axis is "Department" and Y axis is "Age of Ticket". The measure i have is "Count of Tickets". So this graph is displaying for each department how many tickets are there in each "Ageing" category. Ageing category are like 1+, 5+, 10+

which means tickets older than 1 day and less than 5 days, tickets older than 5 days and less than 10 days like that..

 

Now, I need to change the colour of the Bar to RED if a ticket is coming in the 10+ category. i.e if any ticket of a department is older than 10 days that particular Bar should be in RED colour.

 

Please suggest how to implement it. Thanks much!!

 

Cheers

Jim