Average Days To Close

The Average Days to Close dashboard provides insights on the average days taken to mark a deduction as valid or invalid, calculated using the following formula:

Average Days to Close = Number of days taken for closing the resolved deductions / Total resolved deductions

The tiles in the dashboard display the following average metrics for the selected time period.

  • Average Days to Close

  • Number of Deductions Closed

Note

The computational constraints for calculating the metrics are as follows:

  • For a deduction, if the resolved date is not available, the deduction closed date is analyzed.

  • All the deduction amounts are converted to global currency.

  • Weekends are excluded.

For more details, refer to Viewing Dashboards.

Widget 1 - Average Days to Close Trend

The Average Days to Close Trend widget displays a spline and column chart of the monthly trend of Average Days to Close and the count of closed deductions.

Hovering over the series displays a tooltipClosed A tooltip is used to specify extra information about something when the user moves the mouse pointer over an element. of the month and the respective Average Days to Close and Deductions Closed values.

Widget 2 - Average Days to Close Breakdown

The Average Days to Close Breakdown widget displays a column chart of the monthly trend of Average Days to Close segregated into the following categories.

  • Average Days to Touch

  • Average Days to Research

  • Average Days to Close Post Research

Hovering over the series displays a tooltip of the month and the respective Average Days to Touch, Average Days to Research, and Average Days to Close Post Research values.

Widget 3 - Average Days to Close by Deduction Validity

The Average Days to Close by Deduction Validity widget is similar to Average Days to Close Breakdown widget, which displays a bar chart of the following average values for valid and invalid deductions.

  • Average Days to Touch

  • Average Days to Research

  • Average Days to Close Post Research

Hovering over the series displays a tooltip of the deduction type (valid or invalid) and the respective Average Days to Touch, Average Days to Research, and Average Days to Close Post Research values.

Widget 4 - Average Days to Close by Reason Codes

The Average Days to Close by Reason Codes widget displays a bar chart of Average Days to Close for reason codes.

Hovering over the series displays a tooltip of the reason code and the respective Average Days to Close value.

Widget 5 - Average Days to Close by Customers

The customer details widget displays the entire customer data considered for the computation of metrics in the dashboard for the selected time period. Click the download icon to export the data as a CSV file in your local system.

Out-of-the-Box Features

The Out-of-the-Box features and functionalities of the dashboard are as follows:

  • Date Range - Filters data displayed in the dashboard as per the required date range.

  • Daily or Monthly Toggle - Switches the entire dashboard metrics and trends to daily (D) or monthly (M) view.

  • Standard Out of the Box Filters - Filters the entire dashboard on the basis of Company Code and Reason Code.

  • Kebab Menu - Click this icon to access options such as download, schedule, and mark the dashboard as favorite. For more details, refer to Using Kebab Menu Options.