Create PA report on incident table?

[Jaydeee]

Hi Experts,

I have been asked to create a report on incident table. which will show weekly metrices which includes the states like Draft, Closed and cancelled. There will  another column called Completed which is sum of closed+ cancelled.

Appreciate the help.

[Mark Manders]

What is the business case behind this? What value will it bring to have one reports that shows some records twice? You are looking at states, which you understand and then 'completed', which then also looks like another state, because that's what you are looking at. 

I think the 'why' question (what issue are you resolving with having this report) is the one to ask, before getting into all kinds of data retrieval to show something that ends up being unclear.

[Jaydeee]

Thanks for your response.
unclear about the business idea behind it. But the report will show the count of records in each state and another field which will show the sum of cancelled + closed records for clear view of the records which don't require any action.

[AndersBGS]

Hi @Jaydeee ,

According to your requirement - where do you get stuck. Your requirement can be obtained with automated indicators and one formula indicator and combined in one widget populated to a dashboard.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Jaydeee]

can you please share your input as I am new to indicators and formula indicator.Initally I assumed this can be achieved by function field but no luck.