Hello, I'm working on a dashboard for a client and I'm curious if there is a way to apply a filter to a filter. An example is probably helpful here:
We have a data point for "default field value" which pulls from a list of all client default field values which they use for custom account characteristics like "Customer Tier" and "Territory" which are the default field names, the field values would be things like "gold", "silver", "bronze" or "north", "east", "west" respectively.
The issue I'm running into is when I'm trying to create a filter for "Territory". To do this, I need to have a filter on the "Default field value" but then the filter is showing every default field value in their db, instead of just the default field values for Territory.
is there a way to do this?