Hello, I'm working on a dashboard for a client and...
# gooddata-cloud
m
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?
m
Hi Michael, this should be addressed by using a Dependent Filter. The following documentation goes through the whole setup: https://www.gooddata.com/docs/cloud/create-dashboards/filters/dependent-filters-dashboards/.
Note that your LDM needs to allow for the feature to work correctly, otherwise a redo would be needed.
m
Oaky, thanks, i will share with my development team for further input from them. @Adam Steele does this make sense? @Moises Morales something else that may be related: Our customers have the ability to answer survey questions in our app and our client wants to use the survey answer choices as rows in a table visualization. We're running into a similar problem here because survey results are all stored in one data point called "form_results", so when we bring "form_results" into the visualization as rows, it shows every answer to all questions within a survey instead of just the answer choices I want showing as rows. If this were a metric, I would apply an attribute filter and then filter the metric to specific survey question, but the rows area does not allow for attribute filters. Is this another scenario where a dependent filters would be the appropriate way to do this?
m
Hi Michael, my apologies for the delay. I am having issues understanding the issue, you can apply a filter to attributes as well, you just need to drag and drop the corresponding attribute to the filters area. I suggest you send a screenshot showing the issue in case there is something I am missing, feel free to do it via DM in case there is sensitive data involved.
m
@Moises Morales would it be possible for us to screen share so I can walkthrough what I'm encountering?
@Moises Morales here are the details you asked for in our DM