Count of distinct values (line items) for a variable

Avatar

Avatar

gaurav2

Avatar

gaurav2

gaurav2

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 (10 New)
10 Comments

Avatar

Avatar

xptr99210

Avatar

xptr99210

xptr99210

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

creatry

Avatar

creatry

creatry

16-06-2010

I want it by all means!

Avatar

Avatar

richpagedol

Avatar

richpagedol

richpagedol

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

MGraham

Avatar

MGraham

MGraham

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

MGraham

Avatar

MGraham

MGraham

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

mubarakd5726232

Avatar

mubarakd5726232

mubarakd5726232

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

alyson_murphy

Avatar

alyson_murphy

alyson_murphy

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

MichaelWon

MVP

Avatar

MichaelWon

MVP

MichaelWon
MVP

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

mubarakd5726232

Avatar

mubarakd5726232

mubarakd5726232

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

mubarakd5726232

Avatar

mubarakd5726232

mubarakd5726232

08-01-2018

found ..

Approximate Count Distinct (dimension)

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