Calculate percentil 95 over a dimension and group by day

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:
 

78f29225-852e-4ff4-8261-1db32f33ab26.png

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 0 1,217
0 REPLIES 0
Top Labels in this Space
Top Solution Authors