how to calculate Average Days Open (1 Day, 2 Days, +3 Days) and Percentage in report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2024 04:07 AM
Hi,
I have created a report to the below information.
Name of Report: Customer Report
Type of Report: Bar Graph
Data Elements Required: Customer Name
Total Number of Cases
Case Type and Percentage
Case Sub Type and Percentage
Average Days Open (1 Day, 2 Days, +3 Days) and Percentage
But how to calculate Average Days Open (1 Day, 2 Days, +3 Days) and Percentage in the same report.
Can anyone please help on this, It will be useful.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2024 04:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2024 01:56 AM
@Dr Atul - LNG , @Mark Manders , @AndersBGS
Thanks for responding!
Can anyone please tell me what is the exact plugin for PA? and also is that paid or free plugin?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2024 02:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2024 04:21 AM
This can't be done in one report. Just put the data on a dashboard to show everything instead of putting it in one report that needs explanation to read.
To get the data calculation you will need to use PA.