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

Optional eVar as a percentage of visits

Avatar

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile
David-123
Level 5

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
View Entire Topic

Avatar

Avatar
Coach
MVP
Andrey_Osadchuk
MVP

Likes

509 likes

Total Posts

917 posts

Correct Reply

243 solutions
Top badges earned
Coach
Contributor
Seeker
Bedrock
Boost 500
View profile

Avatar
Coach
MVP
Andrey_Osadchuk
MVP

Likes

509 likes

Total Posts

917 posts

Correct Reply

243 solutions
Top badges earned
Coach
Contributor
Seeker
Bedrock
Boost 500
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