Reporting on Count,Percentage

[Abish]

Hi All,

I have the below requirement to be implemented on Reports :

I tried creating DB views between the group table and the Incident table,but that did not helped me to calculate the count and the percentage. I need this report on a Excel List format. I am a beginner on PA and I tried creating a List Widget on the PA but not sure how to get this columns on the Report. Can anyone suggest how to get this implemented.

Thanks in Advance!

Regards 

Abi R

[Community Alums]

Hi @Abish ,

You can try :

1. Data > Incident
2. Type > Time Series > Bar
3. Configure > Group by State, Stacked Bars, Display Data Table, Trend by Created, per Quarter, Count
4. Style > General > Display data labels

Lastly, just hover your cursor on the "Bars" in the report, you will be able to see the "%".

This is the report which i created for you.

Please mark my answer as Correct & Helpful, if applicable.

Thanks

Sandeep

[Abish]

Hi Sandeep,

Thanks for your response. 

I need to display the report on the List format with all the requested fields. Is there a way to do this on a report.

Regards

Abi R

[Community Alums]

HI,

You cannot have the functionality you are looking at in LIST view.

The one which i have shared is the best to suit your requirement.

Please mark my answer as Correct & Helpful, if applicable.

Thanks

Sandeep

[Abish · Accepted solution]

Hi,

This functionality is not possible with the Reports. But Yes PA plugin helps to get this done. 

Below are the steps:

1. Create a PA widget of Type - Breakdown and Visualization - Pivot Table.

2. Added a pivot breakdown of Assignment group

3. Added Automated Indicators with the same breakdown of Assignment Group and added them to the data collector jobs.

4.Created a formula indicator to calculate the percentage.

5. Added all the indicators I created to the Widget I created. 

Regards

Abi R