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
BedrockMission!

Learn more

View all

Sign in to view all badges

Q: Calculated metric - running total percentage of browsers visited

Damu80
Level 1
Level 1

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
Damu80
Level 1
Level 1

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

 

 

 

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