I have this table and the formula for duration is:
the formula for the grouped and sorted is:
when i used count distinct to count the instances of the multiple days(e.g. 1 day occurred 8 times, 2 days occurred 5 times) it wasn't displaying the correct count..
Help please :)