Hi,
I am trying to calculate median for differences between dates in Looker using datediff function and median in measure as shown in the following screenshot:
Seems like the median is not calculated well, for example for the following date differences:
The median calculated is 103, and not the average between 103 and 64.
The sql used to calculated the median is as shown bellow:
What is the problem?