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.