You need to sign in to do that
Don't have an account?
Filtering out null picklist values in Report/Dashboard
In the report builder I have a chart based on report data, and I'm trying to filter out all the results where a certain picklist value is not defined (null).
So in the Report filters I added the condition if Picklist_Value__c does not equal "" . This had the desired effect in the report's chart as all non-defined picklist values were filtered out.
However, when I go to the Dashboard, import the report (refreshing just to be sure) the data appears with the null values unfiltered. I don't understand why it would not be the same as the diagram in the report, but maybe it has to do with the fact that there is a hyphen. I.e. it says that hyphen (-) has 21 results, valueA 13, valueB 6 etc... so it is not passing the filter.
Obviously I can't filter with a hyphen because it isn't a valid picklist value. How do I prevent null results from appearing in my Dashboard?
When I Add a Chart in the Report Builder with the filter, the null values are correctly filtered out of the chart. However, when I Run the Report, the null values reappear and are subsequently reflected in the dashboard.
Hi,
Please follow the steps
If my solution worked for you mark it as resolved.
Thanks.
Regardless of the filtering attempts my reports continue to list records with null entries in the field
Thanks @dev_fire