cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

USQL: Firebase style distribution of all the percentiles of visualCompleteTime for a userAction

tolis_christoma
Newcomer

I would like to see how many users fall in the percentiles of visualCompleteTime like Firebase does

 

I tried different queries with USQL but I didn't get the result.

Because the visualCompleteTime values are different for each user if I use group by I get groupings of maximum 3. Is it possible to aggregate these values?

To be more specific below is an example from firebase (the x-axis represents a larger array of load times. The y-axis represents the percentiles ) and here is the article that explains why these area charts are very useful

https://medium.com/firebase-developers/how-fast-should-your-site-load-cfb14be48e8b

1 REPLY 1

tolis_christoma
Newcomer

I managed to find something very close to the above under the performance of an user action, see visually complete distribution. Is it possible to generate the same with USQL?