Sort 'sdiff' results
I'm trying to figure out how to calculate the elapsed time between two data points in a record and then sort the results into different buckets. We use an embedded version of Sisense so I can't edit ...
Forum Discussion
Hi,
Thank you for your question. To use the DDIFF function, you should wrap it in f.e. aggregation.
AVG(DDiff([Days in Discharge_Time],[Days in Admission_Time]))
or SUM.
You can provide an example of the data set and expected result, and I will try to provide a solution for you.
The vendor has a prebuilt calculation for this but unfortunately it doesn't work in our specific use case as it skews the data. I can use their calculation to show you my desired output though. I'm looking to create two widgets that bucket chart completion times.
The first would be an aggregated column chart that looks at all records. It would look like this.
Here is how it is built
That "Time to Locked Status" is the prebuilt calculation I can't use and needs to be replaced by an SDIFF function. Each value in the chart is sorted by right clicking on "Time to Locked Status" and putting a filter there.
The problem is that I can't aggregate the SDIFF with an Average or Median. I need it to look at the SDIFF for every record and then filter the results.
The second widget is essentially the same construction just in pivot table form with the rows showing each individual person's performance.
