Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Q: Calculated metric - running total percentage of browsers visited

Avatar

Level 2

Hello, Lets assume that on our site developments teams tests its application with browsers that consist at least 80% of traffic on any given time. Now I should only know what they those browsers are, and tell them, right 🙂

 

I can easily list the percentage share of each browser, but how to make a calculated metric that would list the browsers needed to break that 80% threshold. For example on the snip attached the last browser would be Safari 13.0.5

 

Of course i could always tell team to count them by themselves, or use take csv-file but im looking for more elegant way... 

Thanks tr 

 

browser_running_total.JPG

3 Replies

Avatar

Level 2

Thanks Andrey,
I have used cumulative function using dates before succesfully, but with this case my approach did not work.

 

I checked your link once again, and it stated, that "Since it's ordered by the dimension it's only useful on dimensions that have a natural order like date or path length." so to my understanding my case cannot be solved, as my dimension is not 'Day', 'Month' but rather 'Browser' which doesnt have a natural order. What i get, see below. On dates it works fine, but Browser cumulative table does not make any sense

 

BR, tr

 

browser percentage.JPG

 

 

 

Avatar

Community Advisor
Yes, you are right, the cumulative function will not work with this dimension. Sorry for pointing you to a wrong direction.