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

Count of distinct values (line items) for a variable

Avatar

Avatar
Boost 50
Level 6
gaurav2
Level 6

Likes

161 likes

Total Posts

44 posts

Correct reply

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

Avatar
Boost 50
Level 6
gaurav2
Level 6

Likes

161 likes

Total Posts

44 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
gaurav2
Level 6

18-02-2010

Very often a user doesn't know the total number of distinct values for a variable. It would be quite helpful if the same is shown somewhere (as was in HBX - in the last row where the total metrics were shown). For example - number of distict Natural Search Keywords that received at least one response - quite important a metric for SEO health check. Also helps in expecting the number of rows while 'Saving a report'. Currently I end up selecting the maximum possible number (50000 for csv and so on) but I have no clue what the actual number is like.

10 Comments

Avatar

Avatar
Boost 5
Level 4
xptr99210
Level 4

Likes

40 likes

Total Posts

29 posts

Correct reply

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

Avatar
Boost 5
Level 4
xptr99210
Level 4

Likes

40 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
xptr99210
Level 4

28-02-2010

I also have to do an export to Excel and do a sum to get the total of unique items.  If it was on HBX, it should be on SC as well.

Avatar

Avatar
Level 1
creatry
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
creatry
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
creatry
Level 1

16-06-2010

I want it by all means!

Avatar

Avatar
Boost 5
Level 2
richpagedol
Level 2

Likes

22 likes

Total Posts

4 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
richpagedol
Level 2

Likes

22 likes

Total Posts

4 posts

Correct reply

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

12-08-2010

I totally agree with this one too - our SEO team has been putting serious pressure on me to get this. Very annoying that you can't get this in Omniture, but you can get it in Google Analytics. This particularly helps understanding the long tail keywords effect, and being able to monitor this year over year.

 

Please add this function ASAP!

Avatar

Avatar
Boost 50
Level 4
MGraham
Level 4

Likes

55 likes

Total Posts

42 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
MGraham
Level 4

Likes

55 likes

Total Posts

42 posts

Correct reply

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

22-02-2016

One thing I think that Analysis Workspace does better than Site Catalyst is they have easy reference for the total count of rows a dimension has. For instance, if I want to see the total count of customers I have within Analysis Workspace, all I have to do is look at the dimension and it tells me the total right there. In Site Catalyst, I have to type in an absurdly large number to make sure I get to the last entry and then note that.

 

Thank you!

Avatar

Avatar
Boost 50
Level 4
MGraham
Level 4

Likes

55 likes

Total Posts

42 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
MGraham
Level 4

Likes

55 likes

Total Posts

42 posts

Correct reply

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

23-06-2016

@gaurav2

 

I came back across this post and have since figured out a work around that has worked for me.

 

count.png

 

In this instance, I just selected day as my dimension and made a metric called "Visit count". It says the number is 23 for each row in the dimension. What it is doing is returning the count where the value of visit eqists. In essence, I have 23 row items in my dimension so it counts in the same manner that you were talking about. I use this metric on other dimensions when trying to figure out the count without having to scroll through like you discussed.

Avatar

Avatar
Give Back 25
Level 5
mubarakd5726232
Level 5

Likes

87 likes

Total Posts

90 posts

Correct reply

3 solutions
Top badges earned
Give Back 25
Ignite 5
Ignite 3
Contributor
Shape 25
View profile

Avatar
Give Back 25
Level 5
mubarakd5726232
Level 5

Likes

87 likes

Total Posts

90 posts

Correct reply

3 solutions
Top badges earned
Give Back 25
Ignite 5
Ignite 3
Contributor
Shape 25
View profile
mubarakd5726232
Level 5

25-11-2016

Raised previously but a count of unique values in a dimension would be very handy (without visually looking at row count). As a publisher I'd like to correlate/trend unique article ids with traffic.

Avatar

Avatar
Boost 50
Level 4
alyson_murphy
Level 4

Likes

59 likes

Total Posts

33 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
alyson_murphy
Level 4

Likes

59 likes

Total Posts

33 posts

Correct reply

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

01-12-2016

I agree with the issue highlighted above. To be more specific about what the solution looks like, in the Calculated metrics, I am looking to be able to put a Dimension inside the `Count` (or maybe a `Count Distinct`) so that I could have COUNT(DISTINCT evar 03 values) without having to do odd stuff with row counts. I am looking to be able to graph that count over time without having to jump through a bunch of hoops.

Avatar

Avatar
Give Back 3
Level 9
MichaelWon
Level 9

Likes

439 likes

Total Posts

91 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 5
Ignite 3
Give Back
Ignite 1
View profile

Avatar
Give Back 3
Level 9
MichaelWon
Level 9

Likes

439 likes

Total Posts

91 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 5
Ignite 3
Give Back
Ignite 1
View profile
MichaelWon
Level 9

20-12-2016

what about the row count function in calculated metrics?  it shows the same value for each row but is a work around.

Avatar

Avatar
Give Back 25
Level 5
mubarakd5726232
Level 5

Likes

87 likes

Total Posts

90 posts

Correct reply

3 solutions
Top badges earned
Give Back 25
Ignite 5
Ignite 3
Contributor
Shape 25
View profile

Avatar
Give Back 25
Level 5
mubarakd5726232
Level 5

Likes

87 likes

Total Posts

90 posts

Correct reply

3 solutions
Top badges earned
Give Back 25
Ignite 5
Ignite 3
Contributor
Shape 25
View profile
mubarakd5726232
Level 5

08-01-2018

anyone found a good work around for this without having to use row count which wouldn't work if you want multiple distinct counts in one table (for visualization) .. or is this on roadmap ?

Avatar

Avatar
Give Back 25
Level 5
mubarakd5726232
Level 5

Likes

87 likes

Total Posts

90 posts

Correct reply

3 solutions
Top badges earned
Give Back 25
Ignite 5
Ignite 3
Contributor
Shape 25
View profile

Avatar
Give Back 25
Level 5
mubarakd5726232
Level 5

Likes

87 likes

Total Posts

90 posts

Correct reply

3 solutions
Top badges earned
Give Back 25
Ignite 5
Ignite 3
Contributor
Shape 25
View profile
mubarakd5726232
Level 5

08-01-2018

found ..

Approximate Count Distinct (dimension)

.. any plans on getting an exact count ? dontaskdontget​