Hello experts, I need help creating KPIs. I have a chart which shows Percentage by Total Tickets Closed . I have days range as my dimension
Map_IntervalMatch_Days:
Load
Dual([Days Range], RowNo()) as [Days Range],
[Min Days],
[Max Days]
Inline [
Days Range, Min Days, Max Days
0 Days, 0, 0
1-10 Days , 1, 10
11-30 Days , 11, 30
31-60 Days, 31, 60
61-120 Days, 61, 120
121+ Days, 121, 9999999999
]
And for my measure, I have the following code
(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]))
I need to create a KPI to indicate red when <90% of tickets are closed within 30 days and green if >=90% of tickets are closed within 30 days.
Any suggestions will be appreciated
