Percentage calculation OOB report

[abirakundu23]

Hi All,

If we want to show what percentage of total closed cases in January were closed incomplete. Let's say there were 1,000 closed cases in January. 2 of them were Closed Incomplete.is it possible OOB report concept ? We have Created visualization that display total Closed incomplete HR cases during Jan 24 to Jan 25 timespan where report type is Trend & according OOB functionally its showing count as well percentage. could you please assist can we accommodate  in existing OOB report  or we have to create performance analytic to achieve the scenario.

[Mark Manders]

You could just show a donut chart of complete vs incomplete. That enables showing percentages as well and allows for the total number in the middle.

[abirakundu23]

Hi @Mark Manders,

I have created & select donut, however its showing like that.

[J Siva]

Hi @abirakundu23 

You can create a trend type report and check display data table check box.

So that you can see the percentage details for each state & don't create a filter condition on the "state" field, as it may manipulate the percentage result. PFB the snap of sample report created on incident table.

Hope this helps.

Regards,

Siva

[abirakundu23]

Hi @J Siva , I have did for that. please help me " what percentage of total closed cases in January were closed incomplete. Let's say there were 1,000 closed cases in January. 2 of them were Closed Incomplete", what will be the percentage ? Can we accommodate any existing report which is not monthly basis. Please assist.