Question

Calculate percentil 95 over a dimension and group by day

  • 31 December 2021
  • 0 replies
  • 21 views

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:

percentile(${time},0.95)

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


0 replies

Be the first to reply!

Reply