Totals in Calculated Metric Columns | Community
Skip to main content
adamgreco0
adamgreco0
Level 7
Feb 11, 2010 10:45 PM UTC
Delivered

Totals in Calculated Metric Columns

Currently, if you have a Calculated Metric in SiteCatalyst and it is added to an eVar report, you cannot see the totals of the column.  This is quite annoying and forces you to pull data down to Excel and run a total there.

    11 replies

    jgrover1
    Employee
    Jun 22, 2015 9:49 AM UTC

    With the latest release of Adobe Analytics we have added totals for Calculated Metrics where it make sense and they are smart (e.g. not a simple sum of conversion rates) but they take the data from the whole site.

    Translate
    katyn15
    katyn15
    Level 3
    Apr 9, 2013 10:47 AM UTC

    They need to give you the option to choose a SUM or AVERAGE for the TOTAL row when creating calculated metrics. Otherwise conversion rates are summed, which is rediculous.

    Translate
    torontoseo6
    torontoseo6
    New Participant
    Nov 12, 2012 6:20 AM UTC

    This seriously needs to be fixed. It's a major problem that seems easy  to fix

    Translate
    gangster_gal
    gangster_gal
    New Participant
    Feb 28, 2012 11:08 AM UTC

    Please make this available by default.

    Translate
    cmericle2
    cmericle2
    Level 2
    Jan 4, 2011 6:31 AM UTC

    Omni you have to fix this.  The data is already in your interface, you just have to sum them.  

    Translate
    phils71661113
    phils71661113
    Level 3
    Apr 13, 2010 11:10 PM UTC
    I think this works great, and I was wrong, n/a is not at the bottom. (I should have pulled my report rather than recall from memory.) Here's an example screenshot where I've broken down my 'All' category by the product lines I've uploaded in the table above. You can see calculated total metrics, average metrics and conversion metrics all display correctly at the top.
    Translate
    adamgreco0
    adamgreco0Author
    Level 7
    Mar 31, 2010 9:06 AM UTC

    If it still has n/a at the bottom, I am still stuck!  Thanks for providing this info though.  IT can help solve part of this issue...

    Translate
    phils71661113
    phils71661113
    Level 3
    Mar 31, 2010 7:44 AM UTC
    Step 1: Add an "All _____" Classification to your SAINT table. Conversion Classifications
    Step 2: Upload your SAINT table with the same value in your "All" column for all rows. Example SAINT Table
    Step 3: View your "All ___" report with your calculated metrics. Report screenshot.gif
    Step 4: Click the Green icon to the left of "All" and break the report down by another to see the totals displayed at the top for that report. (Note: It will still say n/a in the totals fields at the bottom of the report.
    Translate
    adamgreco0
    adamgreco0Author
    Level 7
    Mar 18, 2010 11:45 AM UTC

    Can yo share an example/screenshot of the SAINT solution? I'd love to see it?

    Translate
    phils71661113
    phils71661113
    Level 3
    Mar 18, 2010 10:39 AM UTC

    What's frustrating is calculated metrics will total IF you are breaking down one report by another:

    Calculated metric totals after breakdown





    And as a bonus, this totals at the top of the page, which is great if you stick a long report into a reportlet.



    As a temporary soluion, I have created a column in various SAINT tables that contain the same value for all rows, then break down a report by that item. It will total calculated metrics AND put them at the top of the report.

    Translate
    Show more replies
    Terms & ConditionsAccessibility statement

    Loading footer...