Optional eVar as a percentage of visits

[#1]

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 

	Visits	Percentage of visits with this error
Unspecified	980	98%
Error Code 1	100	10%
Error Code 2	40	4%
Error Code 3	30	3%
Error Code 4	30	3%
Error Code 5	20	2%

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

[brentrad · Accepted solution]

Hi David,

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

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

[brentrad · Accepted solution]

This will work as long as you leave the "Include Unspecified (None)" option checked in the Analysis Workspace table. If you uncheck it and the eVar is not set on every call (i.e. there isn't a value set in 100% of visits) then the Total and Grand Total values will be different. Adobe uses the "Total" as the denominator rather than the Grand Total, so you'll wind up only comparing an eVar value to the total visits with the eVar value.

[#4]

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.