More unique values in a column than rows, in an Advanced Salesforce Connector
I have an Advanced Salesforce Connector pulling account ID's into Domo, the column for account ID's has 405k unique values when there are only ~399k rows in the dataset.
Does anyone know why this might be happening?
0
Comments
-
I'm not sure those values are exact. What happens if you build a card from the data set and use
count(distinct `Account ID SF`)
In theory, you should end up with the same number of rows as your dataset. Not sure why (or how) there could ever be more. Sounds like a bug to me.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 524 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive