Maximum Number of Rows that Can Be Displayed on a Card
In a card, the data display is limited to 100,000 rows, but if the DataSet has 1,000,000 rows of data, does anyone know which of the following will happen?
1) If the data after filtering is within 100,000 rows, it can be displayed normally.
2)Regardless of the content of the filter, the error of over 100,000 rows will be displayed.
As far as we have tried, we think it will be the case 2 above. However, one of our engineers uploaded more than 100,000 rows of data from a Web Form and did not see any errors.
Best Answers
-
Hi @Tow, I believe you'll get an error if the rows, from the dataset, coming into the card are typically more 100,000, and if you apply filters (in ETL or card) and/or set a number limit in the Chart Properties (see below), it should display without issues.
This is an excerpt from here: https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs:
You can now use the Limits Row command inside of the Analyzer to set values larger than would otherwise be possible. To keep the responsiveness fast on your Dashboards, the chart engine limits the number of rows it downloads to the browser. Now you can override these limits by explicitly setting these values.
9 -
A Domo consultant has responded to my question above. He said the correct answer is 2.
0 -
0
Answers
-
From the KB Article https://domohelp.domo.com/hc/en-us/articles/360043429573-Table-Chart
You can have up to 25,000 rows in a Mega table.
If you are viewing your dataset in the data center and export to CSV, you may be able to export up to 1m rows.
**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 -
Hi @Tow, I believe you'll get an error if the rows, from the dataset, coming into the card are typically more 100,000, and if you apply filters (in ETL or card) and/or set a number limit in the Chart Properties (see below), it should display without issues.
This is an excerpt from here: https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs:
You can now use the Limits Row command inside of the Analyzer to set values larger than would otherwise be possible. To keep the responsiveness fast on your Dashboards, the chart engine limits the number of rows it downloads to the browser. Now you can override these limits by explicitly setting these values.
9 -
Hi @MarkSnodgrass and @amehdad, thank you for your answer. Let me add a few words about my question.
I imagine that the filters are handled by the front-end. Therefore, I would like to know the following:
1) Error if there are more than 100,000 rows at the time they come into the Domo front end
2) Error if the result of filtering by card is over 100,000 rows.
In the case I'm working on, the DataSet has millions of rows of data. If the Domo process is case 2, then we can design filters for each department to ensure that there are always less than 100,000 rows of data displayed. That way no data will be missing and it will be displayed correctly.
0 -
A Domo consultant has responded to my question above. He said the correct answer is 2.
0 -
0
-
A Domo consultant has responded to my question above. He said the correct answer is 2.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive