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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Difference in Percentages in Freeform Table

lindsaya8085303
Level 1
Level 1

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

1 Accepted Solution
ashokkumarm
Correct answer by
Level 5
Level 5

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

View solution in original post

0 Replies
Andrey_Osadchuk
Community Advisor
Community Advisor

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

lindsaya8085303
Level 1
Level 1

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

Andrey_Osadchuk
Community Advisor
Community Advisor

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

lindsaya8085303
Level 1
Level 1

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

ashokkumarm
Correct answer by
Level 5
Level 5

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

View solution in original post

Andrey_Osadchuk
Community Advisor
Community Advisor

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
Level 1

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!