Basic Reporting application: how to report Average Age of OPEN records from TASK table?

[rhodisf]

is there a way to create a Single Score type report in the Reports Application that shows "Average Age of Open Records"?    I know about PA, however, that is not an option.  I just need to show this executive that we can show this number..... Average age of open records assigned to a specific assignment group.   so far, filter criteria is this:

from the TASK table:

Active=true

Assignment group = AM 

has any body done this?

thank you so much for your inputs.

Rhonda

[AndersBGS]

Hi @rhodisf ,

You can utilize the single score visualization with below settings:

Then just add a filter:

Active is true

state is not //the states that you would like to exclude.

Furthermore, I would always recommend to do reports on incident, change request etc. etc. and not directly on task table.

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

Best regards

Anders

[Shweta Yaksambe]

Hello @rhodisf ,

Navigate to view/run and click on create a report

Give the report name, select the source type as Table and table as task

Select the Single Score as type

In configure select Aggregation as Average and Business duration

Then in filter condition add active is true and Assignment group as Hardware

Then save the report and click on Run

Below are the Screenshots

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

Best regards

Shweta