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

Difference in Percentages in Freeform Table

Avatar

Avatar
Level 1
lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile
lindsaya8085303
Level 1

06-09-2019

I have a table of visits split by channel. I have turned off numbers so that I can just see each channel as a % share of the total - I have this for TY and LY and am wanting to create a new column that will tell me the difference between the two percentages.

When calculating as a percentage change, or as one minus the other I am getting stupid numbers. Using a Summary Change Visualisation with Raw Difference gives me the right number but I can't seem to replicate in my table.

Anybody experienced/solved this before?

Current set up of Freeform Table:

1828536_pastedImage_0.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct Reply

12 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 10
Give Back 5
View profile

Avatar
Establish
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct Reply

12 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 10
Give Back 5
View profile
ashokkumarm
Level 5

09-09-2019

Hi lindsaya80853039

By Right Clicking Share of Visits under "3 Months - TY", you can able to compare the data with custom data range.

Menu: Right Click > Compare to periods > Custom Date range to this range

1829882_pastedImage_0.png

Try this method you will get the % difference.

Regards

Ashok

Answers (6)

Answers (6)

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

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

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

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

06-09-2019

Look for the metric settings when working in the metric builder.

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

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

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

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

06-09-2019

Try this formula in calculated metric builder = TY[ Visits/TotalVisits ] / LY[ Visits/TotalVisits ] -1

Avatar

Avatar
Level 1
lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile
lindsaya8085303
Level 1

09-09-2019

Apologies, I didn't realise I had said percentage not percentage point - however I've now managed to work out how to adjust it. Thank you so much for your help!

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

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

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

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

09-09-2019

Lindsay,

2.55% shows by how much 32.88% is higher than 32.06%. Is not it what you were looking for?

Avatar

Avatar
Level 1
lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile
lindsaya8085303
Level 1

08-09-2019

Got this now - thank you! However, the numbers still don't seem to make sense with the formula above?

1829535_pastedImage_0.png

Set up of Difference in Share of Visits:

1829536_pastedImage_1.png

Avatar

Avatar
Level 1
lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile
lindsaya8085303
Level 1

06-09-2019

How would you go about creating a Total Visits metric for this formula?