Supermetrics Support Forum

Solved

GA - Exact Value Comparison Data

Hello - I'm trying to compare one period of time to another period of time and show the difference between the two. Ideally the spreadsheet would show


- Last months goal completions

- Current month's goal completions

- Exact value difference between the two


I'm currently displaying the current month and previous month values and calculating the change in another spreadsheet (image attached) but wanted to know if you could just auto calculate it via a query. 


Thank you!


  • Hi John,

    There is a built-in comparison setting but it doesn't return the value for the prior month's data along with the absolute change (you only get one or the other). So it doesn't do exactly what asked but maybe it gets you closer?

    image


    Absolute change:


    image


    Comparision value:


    image


    -Thank you

    Supermetrics Team

Login to post a comment