Filtering Against "Potential" Field Values

afieweger

I'm trying to create a dashboard filter view for a set of field values where some values are not in the current data set but could be in time.

Right now, it seems I can only filter based on available data and not able to set up a filter for potential field values.

Is there any simple way to establish these potential values for a filter?

Thank you

ArborRose

I've done something like this by injecting a column into the dataset using a calculated field. As long as the name is the same, including the case. Later, I circled around and used the field with real data.

ColemenWilson

Do you want this to be a filterable value or you just want to filter out these values?

If you just want to filter out the values, you could do it in an ETL.

If you want this to be an option to select, you would need to add the value to the field and then just have a blank row of data beside the filter value in the field. Your data would end up looking something like this:

ArborRose

I've done something like this by injecting a column into the dataset using a calculated field. As long as the name is the same, including the case. Later, I circled around and used the field with real data.

ColemenWilson

Do you want this to be a filterable value or you just want to filter out these values?

If you just want to filter out the values, you could do it in an ETL.

If you want this to be an option to select, you would need to add the value to the field and then just have a blank row of data beside the filter value in the field. Your data would end up looking something like this: