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?
Best Answer
-
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!
2
Answers
-
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.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
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!
2 -
@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.
1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive