How do I remove duplicate values in my data set?
I have a data set based on a report in Salesforce.
I am trying to create a single bar chart that displays:
X - Created Date
Y - Count of Account (by Account ID)
In my data set, there are multiple rows with the same Account name, but each account has a unique ID. So even though there are 1,070 rows, there are only 905 unique Accounts (based on unique ID).
My report is still capturing every row, but I need it to know that the Account ID's are unique to the Account and to not count the duplicates.
How can I build my report to filter out the duplicate unique Account ID's?
Best Answer
-
You can create a BeastMode function which returns the count of distinct (unique) values for a given column like so:
COUNT(DISTINCT `AccountId`)
Let us know if that helps you.
1
Answers
-
You can create a BeastMode function which returns the count of distinct (unique) values for a given column like so:
COUNT(DISTINCT `AccountId`)
Let us know if that helps you.
1 -
That's the ticket. Thank you!
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 211 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 18 Automate
- 355 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive