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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Need option to get report Totals and line-item counts in ReportBuilder

Avatar

Avatar
Boost 50
Level 9
normcloutier8
Level 9

Likes

450 likes

Total Posts

66 posts

Correct reply

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

Avatar
Boost 50
Level 9
normcloutier8
Level 9

Likes

450 likes

Total Posts

66 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
normcloutier8
Level 9

08-03-2010

ReportBuilder is very powerful, but for us lacks two key elements from the SiteCatalyst UI....

 

1. I can specify a number of ranked records to pull, but there is no way to get the report total that is provided on the bottom of every SC report page.

 

2. As stated in another idea for the SC interface, we need to also access the total number of line items, or unique entries, in any report from within ReportBuilder.

2 Comments

Avatar

Avatar
Boost 5
Level 2
sunshynegirl84
Level 2

Likes

15 likes

Total Posts

16 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
sunshynegirl84
Level 2

Likes

15 likes

Total Posts

16 posts

Correct reply

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

17-08-2010

I completely agree with #1.  Sometimes I know there are going to be more than 50,000 records returned in a report, but I still need to have the grand total of all records for that variable (without specifying the top "n" instances), in order to calculate an accurate % of total in an automated fashion.

Avatar

Avatar
Level 1
gescargu
Level 1

Likes

0 likes

Total Posts

54 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
gescargu
Level 1

Likes

0 likes

Total Posts

54 posts

Correct reply

0 solutions
View profile
gescargu
Level 1

03-05-2016

With the new calculated metrics release from last year, you can now use the countof() function to get hte number of unique values for a given dimension.