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?