Dropdown filter only seeing a few options
I have a dropdown filter card that is not showing all available options that should be showing up. Here is the filter card:
As you can see I only have 2 options in the dropdown, but if you look at the filter for the same column:
You can see that there are many more that this filter should be seeing in it's dropdown. Why does this happen?
If this a suggestion above helps the customer resolve the issue on their end, please provide the outcome of this case for addressing any future issues that may arise.
Best Answer
-
Hello @AKnowles The answer to this is simple. If there is too much information in the table you will only see a few options in the dropdown due to the amount of rows that you are trying to process. The group by option was designed to remedy this. If you group it by the same field, it should aggregate the data and show you all options as expected.
This is documented here:
https://domo-support.domo.com/s/article/4533903600407?language=en_US
"The other field is called "Group By." Though this field is required to power up the Card, in general, it doesn't matter what column you drop here. If you need to aggregate the data, you can use this column to do so. For example, if the column with the filter names is duplicated in your DataSet, you can make the filter names unique by aggregating."If this a suggestion above helps the customer resolve the issue on their end, please provide the outcome of this case for addressing any future issues that may arise.
0
Answers
-
This happened to me today as
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hello @AKnowles The answer to this is simple. If there is too much information in the table you will only see a few options in the dropdown due to the amount of rows that you are trying to process. The group by option was designed to remedy this. If you group it by the same field, it should aggregate the data and show you all options as expected.
This is documented here:
https://domo-support.domo.com/s/article/4533903600407?language=en_US
"The other field is called "Group By." Though this field is required to power up the Card, in general, it doesn't matter what column you drop here. If you need to aggregate the data, you can use this column to do so. For example, if the column with the filter names is duplicated in your DataSet, you can make the filter names unique by aggregating."If this a suggestion above helps the customer resolve the issue on their end, please provide the outcome of this case for addressing any future issues that may arise.
0
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