Why is my card missing rows?
I have a card that only has 11,517 rows but the dataset feeding into it has 12,999. So somewhere between the dataset and the card, it's filtering out 1,400 rows. I don't have any filters in place, all I'm doing is specifying the columns that need to be added, and all of the columns that I've specified include data for the rows that are missing. Does anyone have any idea why this would be missing? I have screenshots showing the discrepancies of rows below (no. of tracks is the same count as rows).
Best Answer
-
@ljb18 what field is being used to count the number of tracks? That field likely has blanks in it and the summary number will not count blanks as part of its total. Find a column that does not have any blanks or nulls and use that as your count for the summary number and you should see the same number as your dataflow row count.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.3
Answers
-
@ljb18 what field is being used to count the number of tracks? That field likely has blanks in it and the summary number will not count blanks as part of its total. Find a column that does not have any blanks or nulls and use that as your count for the summary number and you should see the same number as your dataflow row count.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.3
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 111 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 779 Beast Mode
- 75 App Studio
- 43 Variables
- 735 Automate
- 186 Apps
- 471 APIs & Domo Developer
- 64 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 138 Manage
- 135 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive