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

Return to top
Have more questions? Submit a request

8 Comments

  • John Bowles

    Excellent tip!  Thanks Kate!

    0
  • Frank Devoe

    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

    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

    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

    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
    Zendesk team member

    Thanks for coming back to share that info, Frank!

    0
  • Crystal Little

    Can you show how to do this in Explore please? 

     

    0
  • Jessica Blake
    Zendesk team member

    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