Hello Data People!
Need some help in figuring out, how i can do a scoring in Tableau.
For eg, I have few KPI's which we measure on a monthly basis and we give score as 2 and 0.
2= If is with in the target (Green)
0= if its out of target. (Red)
and we can easily calculate the score using Total Possible and Actual.
Now the challlenge is there are few months, in which there is no activity happening for that particular KPI.
From the above eg: Ticket open for <15 days (marked in blue), there are no activities happening, now i want to avoid them from the total calculation.
Any pointers, how to solve this?