Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

## Difference in Percentages in Freeform Table

lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile

lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

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:

#### Accepted Solutions (1)

ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

12 solutions
View profile

ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

12 solutions
View profile
ashokkumarm
Level 5

09-09-2019

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

Try this method you will get the % difference.

Regards

Ashok

MVP

Likes

536 likes

Total Posts

968 posts

263 solutions
View profile

MVP

Likes

536 likes

Total Posts

968 posts

263 solutions
View profile
MVP

06-09-2019

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

MVP

Likes

536 likes

Total Posts

968 posts

263 solutions
View profile

MVP

Likes

536 likes

Total Posts

968 posts

263 solutions
View profile
MVP

06-09-2019

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

lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile

lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

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!

MVP

Likes

536 likes

Total Posts

968 posts

263 solutions
View profile

MVP

Likes

536 likes

Total Posts

968 posts

263 solutions
View profile
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?

lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile

lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

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?

Set up of Difference in Share of Visits:

lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile

lindsaya8085303
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile
lindsaya8085303
Level 1

06-09-2019

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