Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.

Totals in Calculated Metric Columns

Avatar

Level 10

2/11/10

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 Comments

Avatar

Level 6

3/18/10

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.

Avatar

Level 6

3/31/10

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.

Avatar

Level 10

3/31/10

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...

Avatar

Level 6

4/13/10

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.

Avatar

Level 4

4/9/13

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.