Calculate percentil 95 over a dimension and group by day

  • 31 December 2021
  • 0 replies

Hello everyone!

I would like to know if is it possible to calculate a percentil over a dimension and group by date (i have a lot of registers per day)

For example I have something like this:


the column percentil is calculated over the dimension time and I’d like to show the column percentil in a line chart group by each day, ex: 2021-12-31,  2021-12-30. 
I tried to remove the column “time” to be possible to group, but when I did, I got an error at the table calculation percentil


I am calculating the percentil as a table calculation as following:


PS: I don’t have access to create measure or dimensions types.

This topic has been closed for comments