I'm creating a report in query studio. When I pull a data field into the report and apply a filter, it truncates the list of values. For example, I have a list of a couple hundred codes, which are alphabetized, and when I filter it only shows A through part of P. When I run the report I can see the full list of values from A-Z. How can I see the missing values in the filter list?
It also seems like I'm missing some data values that should be in the list. When I search for certain valuesthey don't show up. How can I tell where the data package is being pulled from, how often it's updated, etc. etc?
1. On the left hand side, under "Manage File", click "My Preferences" make sure your default data display is "Run with all data". Note that this is a bad practice - while forming a report, it's better to pull some data or no data at all so as to not burden the system.
2. Your system manager - whoever created the models - will probably know what exactly is in the model and when do ETL processes happen.