How to return first 100 rows of data?
My dataset is refreshing every day, putting the newest data at the top of the dataset. I only want to chart the first 100 rows of data, the most recent. What function would I use in Beast Mode?
0
Best Answer
-
This is actually very easy to do and does not require a beast mode. In the card builder interface, enter the number of rows you would like to display in the "Show Only" field to the left of the chart.
1
Answers
-
The only advice I would add to the solution is to be sure you have your sort order in as it will return the first 100 (or designated number) of rows. If sorted by date, volume, size or whatever else, it will take the number of rows specified.Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.1 -
Where is this functioanlity in the new interface?
0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 894 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部