Optional eVar as a percentage of visits

Avatar

Avatar
Shape 10
Level 6
David-123
Level 6

Likes

120 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile

Avatar
Shape 10
Level 6
David-123
Level 6

Likes

120 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
Level 6

23-11-2020

Hi There,

 

Any help with this would be great. I use Adobe every day and so fully understand why this isn't straight forward but I am looking for a work around if anyone know a solution.

 

I am trying to build the table below for error reporting using a freeform table for errors (tracked as an eVar):

 

Last week = 1,000 visits 

 

 VisitsPercentage of visits with this error
Unspecified98098%
Error Code 110010%
Error Code 2404%
Error Code 3303%
Error Code 4303%
Error Code 5202%

 

The closest I have managed to get is to simply hide the number on the visits metric leaving a percentage. Problem with this is that I don't want unspecified, and if filter out "unspecified" my number drops from 1,000 to 160 or so, meaning the percentages are out.

 

Thanks

 

Dave

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 likes

Total Posts

973 posts

Correct reply

264 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 likes

Total Posts

973 posts

Correct reply

264 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

23-11-2020

Hi David,

Build a metric as follows and you will be able to hide "unspecified" without any impact on the % values:

Andrey_Osadchuk_0-1606152568771.png

 
Best wishes,
Andrey Osadchuk | Launch Inspector, Analytics Connector, Bookmarks

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 4
brentrad
Level 4

Likes

54 likes

Total Posts

82 posts

Correct reply

16 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back
Boost 50
View profile

Avatar
Validate 1
Level 4
brentrad
Level 4

Likes

54 likes

Total Posts

82 posts

Correct reply

16 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back
Boost 50
View profile
brentrad
Level 4

23-11-2020

If you are building this in Analysis Workspace, by default metrics included in a Table show both numbers and percentages. If you hide the Unspecified value, the percentages appear should show you the Percentage of visits with this error. What it won't do, however, is show this in a different column. If you want a separate column called "Percentage of visits with this error", you could create a calculated metric that only includes visits and is called "Percentage of visits with this error". Once created, drag it into your table, click the gear icon next to the metric name, and update the "Table cells" section to only include Percentages.

 

EDIT: I misinterpreted what the original ask was. You are looking to compare visits with a particular value for this eVar to all site visits. The option I presented above isn't going to show that. Changing the visit metric type to "Grand Total" instead of "Standard" won't work in the calculated metric builder won't work because you are applying the metric to a table with the dimensions listed. Another option is to create a calculated metric for each of the values in the dimension, e.g. "Percentage of visits with error 1". Unfortunately this isn't the most scalable solution.