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.
Agreed! The same goes for any traffic source report, the total of the calculated metric doesn't show.
What's frustrating is calculated metrics will total IF you are breaking down one report by another:
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.
Can yo share an example/screenshot of the SAINT solution? I'd love to see it?
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...
Omni you have to fix this. The data is already in your interface, you just have to sum them.
Please make this available by default.
This seriously needs to be fixed. It's a major problem that seems easy to fix
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.