Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a lot of data from our laboratory, and we have a field TAT (turn around time).
I need to make a table where only the rows of the table are shown where the TAT is bigger than 90% of all TAT's.
The condition is something like this: TAT > fractile(TAT,0.90)
But I don't know where or how to put it in my table.
Any help?
Thx!
In situations like this I often create a calcualted dimension. Use your condition in the dimension calculation.
hi,
First you need to create pivot table. Add the required dimesnion and in Expression try the below code.
sum(if(TAT > fractile(TAT,0.9), TAT)).
In situations like this I often create a calcualted dimension. Use your condition in the dimension calculation.