Forum Discussion
Helper ISum working time over Total available time
In my data set i have two date/time columns which i've subtracted and created a new column "handling time in seconds" which represents the duration in second for an employee to solve a case. In a day there will be several cases per employee (i meam rows in the same date). Also i have created another column "available time" where i've 28800 as a whole number (the available seconds per working day). I want to measure the percentage difference of total Handling Time "Sum(Handling time in Seconds)" over "total available time" = sum(available Time) .
When i try to visualise this on matrix for a month - day, if in a day there more than one case gives me wrong the sum available time because it is multiply 28800* cases.
HI T-Pan,
It seems like a common issue when measure expression to calculate with multiple aggregations.
For this scenario, I'd like to suggest you take a look at the following blog to know how to handle it:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
2 Replies
HI T-Pan,
It seems like a common issue when measure expression to calculate with multiple aggregations.
For this scenario, I'd like to suggest you take a look at the following blog to know how to handle it:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
