How to show a count of rows from a table chart type as the summary number?

Reply
Highlighted
Yellow Belt

How to show a count of rows from a table chart type as the summary number?

I have a dataset with a list of clients, the site they are listed on, and the count of the articles they've posted (aggregated in the card).  

 

I would like to show a summary number that is the count of the number of clients (which is also the count of the number of rows in the table chart).  Is this possibe?


Accepted Solutions
Black Belt

Re: How to show a count of rows from a table chart type as the summary number?

CdrMarks,

 

The simplest way would probably be to create a beast mode that does a distinct count of the client id. For example:

 

COUNT( DISTINCT `client id`)

 

"client id" would be whatever field you are using to aggregate the records in the table into one row per client.

 

You could then use that beast mode in the summary number.

 

I hope that helps!

View solution in original post


All Replies
Major Blue Belt

Re: How to show a count of rows from a table chart type as the summary number?

Do you have a unique identifier in your dataset, such as ID? If so, you can choose that column in your summary number and choose count and it should display the number of rows that you have in your dataset.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Black Belt

Re: How to show a count of rows from a table chart type as the summary number?

CdrMarks,

 

The simplest way would probably be to create a beast mode that does a distinct count of the client id. For example:

 

COUNT( DISTINCT `client id`)

 

"client id" would be whatever field you are using to aggregate the records in the table into one row per client.

 

You could then use that beast mode in the summary number.

 

I hope that helps!

View solution in original post

Yellow Belt

Re: How to show a count of rows from a table chart type as the summary number?


@MarkSnodgrass wrote:

Do you have a unique identifier in your dataset, such as ID? 


I have the client's username as a string.  The number I see as the summary number equals the number of rows in my dataset.  Since the third column of my table chart is a count of articles per client, it seems I cannot just use Count of username.

Yellow Belt

Re: How to show a count of rows from a table chart type as the summary number?


@zcameron wrote:

The simplest way would probably be to create a beast mode that does a distinct count of the client id.

 This worked perfectly.  Thank you Zack.

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!