How do I add a row or column to display the sum of my metric?

Have more questions? Submit a request

8 Comments

  • John Bowles
    Comment actions Permalink

    Excellent tip!  Thanks Kate!

    0
  • Frank Devoe
    Comment actions Permalink

    Hi Kate,

    How do we create the SUM of two different global metrics?  I attempted to create this as an 'Advanced Metric' on my own but failed.  Then I thought, how about just the SUM of the metics as a new row in the report? 

    1
  • Baxter Robb
    Comment actions Permalink

    I was wondering the same thing as Frank. How do we create a SUM of two custom metrics? I would like to see the data in one column. Right clicking on the Row does not allow me to have a SUM of the different metrics.

    0
  • Frank Devoe
    Comment actions Permalink

    Hi Baxter,

    When working in Insights you'll need to add a new 'advanced' metric.  Once there, select 'Custom Metric' at the bottom of the pop-up. Next you'll select the second tab at the bottom title 'Numeric' and proceed to select the top option of 'Simple Arithmetic.'

    You can not free form the actual recipe.  Instead you'll choose the two metrics from the right side that you want to add together.

    Hope this helps.

     

    1
  • Baxter Robb
    Comment actions Permalink

    Frank!

    Thanks for your help! I actually figured this out not too long after posting this comment! I guess I forgot to update my progress here! 

    Either way, its great to have the info out there now!

     

    0
  • Jessie Schutz
    Comment actions Permalink

    Thanks for coming back to share that info, Frank!

    0
  • Crystal Little
    Comment actions Permalink

    Can you show how to do this in Explore please? 

     

    0
  • Jessica Blake
    Comment actions Permalink

    Hi Crystal,

    You can add subtotals or totals to your query in Explore by heading to Result Manipulation>Totals. 

    Check out Adding totals to results for more information!

    0

Please sign in to leave a comment.

Powered by Zendesk