Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Totals in Calculated Metric Columns

Avatar

Avatar
Boost 500
Level 10
adamgreco0
Level 10

Likes

1,936 likes

Total Posts

123 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
adamgreco0
Level 10

Likes

1,936 likes

Total Posts

123 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
adamgreco0
Level 10

11-02-2010

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

Avatar
Boost 5
Level 2
Melissa_Kavanag
Level 2

Likes

16 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
Melissa_Kavanag
Level 2

Likes

16 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
Melissa_Kavanag
Level 2

10-03-2010

Agreed! The same goes for any traffic source report, the total of the calculated metric doesn't show.

Avatar

Avatar
Validate 1
Level 6
phils71661113
Level 6

Likes

186 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 6
phils71661113
Level 6

Likes

186 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
phils71661113
Level 6

18-03-2010

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

Avatar
Boost 500
Level 10
adamgreco0
Level 10

Likes

1,936 likes

Total Posts

123 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
adamgreco0
Level 10

Likes

1,936 likes

Total Posts

123 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
adamgreco0
Level 10

18-03-2010

Can yo share an example/screenshot of the SAINT solution? I'd love to see it?

Avatar

Avatar
Validate 1
Level 6
phils71661113
Level 6

Likes

186 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 6
phils71661113
Level 6

Likes

186 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
phils71661113
Level 6

31-03-2010

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

Avatar
Boost 500
Level 10
adamgreco0
Level 10

Likes

1,936 likes

Total Posts

123 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
adamgreco0
Level 10

Likes

1,936 likes

Total Posts

123 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
adamgreco0
Level 10

31-03-2010

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

Avatar
Validate 1
Level 6
phils71661113
Level 6

Likes

186 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 6
phils71661113
Level 6

Likes

186 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
phils71661113
Level 6

13-04-2010

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

Avatar
Boost 5
Level 2
cmericle2
Level 2

Likes

16 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
cmericle2
Level 2

Likes

16 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
cmericle2
Level 2

03-01-2011

Omni you have to fix this.  The data is already in your interface, you just have to sum them.  

Avatar

Avatar
Applaud 5
Level 1
gangster_gal
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
gangster_gal
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile
gangster_gal
Level 1

28-02-2012

Please make this available by default.

Avatar

Avatar
Applaud 5
Level 1
torontoseo6
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
torontoseo6
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile
torontoseo6
Level 1

11-11-2012

This seriously needs to be fixed. It's a major problem that seems easy  to fix

Avatar

Avatar
Boost 50
Level 4
katyn15
Level 4

Likes

62 likes

Total Posts

27 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 4
katyn15
Level 4

Likes

62 likes

Total Posts

27 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
katyn15
Level 4

09-04-2013

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.