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 to any 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 to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive