Checkbox Selector not showing all values?
Good morning,
While trying to create a Checkbox Selector to use as a filter, I've run into an issue where the card is only showing some values instead of them all. It's not even a massive data set; it's 15 values. However, when creating the card I see the dreaded "Warning: Not all data is shown" message (14 of the 15 are selectable). Any thoughts on what might be happening here? Limit Rows is set to default (All Rows). This is really weird. Thanks.
Comments
-
If you don't have anything in the optional group by field, I would put the same field that you have in the items field into the optional group by and choose count as the aggregation type. I would also check the date range filter if your dataset has a date field and see which field it is using for the date range. If your dataset has multiple date fields, Domo may be choosing a date field that is incomplete, causing not all fields to display.
If neither of those fix the problem, selecting Reset Chart Properties can help as well. Also, I'm assuming there is nothing in the filter properties that would exclude one of your items.
**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.5 -
That did it! I have no idea why though. Appreciate the insight, as always.
0 -
That's great to hear @Joe_M . If you have the option to accept answer on my response, that will help others in the community.
**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.2 -
Of course.
0 -
Hmmm...I either did or it won't let me anymore. Apologies!
0 -
@MarkSnodgrass this did it for me too, thanks!!! Once I put the Optional Group By and changed aggregation to Count it solved my problem. I only had 12 filter items (most recent 12 months, but it was text format instead of date format).
0 -
yes thank you Mark. No idea why it works but it works so thank you!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive