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.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive