Filtering Against "Potential" Field Values

Options

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

Tagged:

Best Answers

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ColemenWilson
    Answer ✓
    Options

    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:

    If I solved your problem, please select "yes" above

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ColemenWilson
    Answer ✓
    Options

    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:

    If I solved your problem, please select "yes" above