Question
How do I add a row or column to display the sum of my metric?
Answer
To add a sum column or row to a report
- Click the Reporting icon (
) in the sidebar, go to Insights > GoodData > Reports and select the report you'd like to calculate the sum for. - Right click on the column/row title.
- Hover over Sum.
- Select of All Rows for a column or of All Columns for a row.
8 Comments
Excellent tip! Thanks Kate!
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?
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.
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.
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!
Thanks for coming back to share that info, Frank!
Can you show how to do this in Explore please?
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!
Please sign in to leave a comment.