How can I allow end user to "see all" rows?

Hi,
I would like to create a card that shows only 6 rows by default, but have the end user be able to choose to see all the rows (bascailly turning off the limited number of rows) without editing the card in the analyzer to see them. How do I do this?
Is there a filter I can set up to allow users to turn on or off the limited number of rows?
Best Answer
-
You could pull this off using variables as well as a window function to create a row count. To create a row count, create a beast mode like this:
SUM(SUM(1)) OVER(ORDER BY
Start
)Change Start to whatever field you need to order by in your dataset.
Create a variable control. I would use a radio button control that says "Show All Rows" and have Yes and No as values.
Now create a beast mode that you will drag into your filters that checks to see whether it should limit the rows or not. It would look like this:
CASE when
Show All Rows
= 'No' THEN
CASE when SUM(SUM(1)) OVER(ORDER BYStart
) <= 6 THEN 'Include'
ELSE 'Exclude'
END
ELSE
'Include'
ENDDrag this beast mode into your filter and then filter to Include.
Now you can toggle with the variable control to show all rows or just the first 6.
**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.1
Answers
-
You could pull this off using variables as well as a window function to create a row count. To create a row count, create a beast mode like this:
SUM(SUM(1)) OVER(ORDER BY
Start
)Change Start to whatever field you need to order by in your dataset.
Create a variable control. I would use a radio button control that says "Show All Rows" and have Yes and No as values.
Now create a beast mode that you will drag into your filters that checks to see whether it should limit the rows or not. It would look like this:
CASE when
Show All Rows
= 'No' THEN
CASE when SUM(SUM(1)) OVER(ORDER BYStart
) <= 6 THEN 'Include'
ELSE 'Exclude'
END
ELSE
'Include'
ENDDrag this beast mode into your filter and then filter to Include.
Now you can toggle with the variable control to show all rows or just the first 6.
**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.1
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
- 433 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive