Hello experts,
I need your help. I need to color a bar chart based on days range. If the average number of tickets closed within 30 days is less than 90% I want the bar to show red otherwise green. Below is my code and attached is the chart.
(Count({<[Year Closed]={'$(vLastMonthYear)'},[Month Closed]={'$(vLastMonth)'},[Status Name]={'Closed'}>} distinct [Issue ID]))
/
(Count(TOTAL {<[Year Closed]={'$(vLastMonthYear)'},[Month Closed]={'$(vLastMonth)'},[Status Name]={'Closed'}>} distinct [Issue ID]))
