Forum Discussion

AlexW's avatar
AlexW
Cloud Apps
07-08-2024
Solved

Splitting time taken to resolve data by 30/60/90 days

Looking to provide metrics on counting time taken to complete assignments split by 30/60/90 days. Working in the pivot table grouping by "Department" I want to display 3 columns based on DDIFF (st...
dashboards & reporting
  • TriAnthony's avatar
    TriAnthony
    07-16-2024

    Hi AlexW,

    SUM should be used to get the total of the 1s and 0s, i.e. the count of records that match each bucketing criterion. Here's how the formula should look like:

    SUM([ID], IF(MAX(DDiff([Days in START_DATE],[Days in END_DATE]))<10,1,0))

    I also attached a sample dashboard below for your reference. This dashboard uses the Sample Healthcare cube, which is available by default to all dashboard designers. Note: please change the file extension from .txt to .dash before importing to your environment.

     

TriAnthony's avatar
TriAnthony
Admin
07-16-2024

Hi AlexW,

SUM should be used to get the total of the 1s and 0s, i.e. the count of records that match each bucketing criterion. Here's how the formula should look like:

SUM([ID], IF(MAX(DDiff([Days in START_DATE],[Days in END_DATE]))<10,1,0))

I also attached a sample dashboard below for your reference. This dashboard uses the Sample Healthcare cube, which is available by default to all dashboard designers. Note: please change the file extension from .txt to .dash before importing to your environment.