Hi - I am trying to use list widget in the PA Dashboard where I wanted to display a monthly count of the MIs. We have a KPI to measure for the organisation where the YTD MI is not more than X number. While I wanted to should the monthly MIs in the list, I also wanted to have a column that could add up all the month counts and show as YTD value. I can then need to compare the YTD with the target and colour code the YTD based on the target value. I do not see an option to add additional column for YTD MI that could sum of number from the monthly count. Is there a way to achieve this in the list widget? If not, what would be the best way to achieve this?
Note - I choose list widget to provide a summary of all the KPIs across months. For MIs related KPIs, the YTD would be the sum of previous months but I also have other KPIs such as P3 and P4 INC resolution which is in %, this would have the YTD value as average of previous months.
Example of the list widget. Days will be replaced with Months
Thanks
Fareeth
