Difference in Percentages in Freeform Table | Community
Skip to main content
L
lashworth
September 6, 2019
Solved

Difference in Percentages in Freeform Table

  • September 6, 2019
  • 7 replies
  • 4786 views

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:

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ashokkumarm

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

Try this method you will get the % difference.

Regards

Ashok

7 replies

Andrey_Osadchuk
Andrey_Osadchuk
Level 10
September 6, 2019

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

    L
    lashworthAuthor
    September 6, 2019

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

    Andrey_Osadchuk
    Andrey_Osadchuk
    Level 10
    September 6, 2019

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

      L
      lashworthAuthor
      September 8, 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:

      ashokkumarm
      ashokkumarmAccepted solution
      Level 4
      September 9, 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

      Try this method you will get the % difference.

      Regards

      Ashok

        Andrey_Osadchuk
        Andrey_Osadchuk
        Level 10
        September 9, 2019

        Lindsay,

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

        L
        lashworthAuthor
        September 9, 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!

        Terms & ConditionsAccessibility statement

        Loading footer...