Can you upload filters for values that don't exist yet?
My Domo data comes entirely from Brightspace datasets and we're in the early stages of user adoption of Brightspace. I'm running into the problem where I want to create filters, but Domo only lets me filter on existing data, I can't type in filter values pre-emptively.
Example: I want to create a filter that shows how many users graduated from Professor A, B, and C's classes.
- I have a dataset that shows all graduates and their associated professors
- But only Professor A and C have graduates. No one from Professor B's classes have graduated, so they don't exist in my dataset.
- Therefore when trying to apply filters, when I filter on Professor Names, I can select from Professor A and C, but B doesn't appear as an option
Am I missing a really easy solution? I'd love not to have to keep re-checking my reports month by month and adding in the "missing" filter options as they slowly become available.
My random guess is that I could upload a csv file with the values I need, but I don't know how to use it after it's uploaded...
Solutions I tried but discarded:
- Building the filter on the graduates' names. There are 171 in my filter list, but since not all of them have graduated yet, their names don't appear in the data.
- Filtering on who's paying for the graduate. Unfortunately the graduates are coming from a subset of 4 larger cost centres.
Answers
-
I assume you are talking about quick filters on a card. When adding a field to the filters section, just drag it in and don't pre-select anything. Just toggle the Display as Quick Filter to be enabled. As your data changes, new values will automatically show up and you won't need to do anything to the card.
**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.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive