Optional eVar as a percentage of visits

Avatar

Avatar

David-123

Avatar

David-123

David-123

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

Workspace

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Andrey_Osadchuk

MVP

Avatar

Andrey_Osadchuk

MVP

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

brentrad

Avatar

brentrad

brentrad

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.