So I have a group of Problems in a report that are pre filtered to a specific product. The dashboard shows a table with Problem ID, Subject and incident count. I have a filter for time and a filter for subject. When I click the dropdown to filter by subject it shows all subjects in the entire database, I would like it to only show subjects from unsolved/closed problems and if possible only show subject options that are available in the current data set based on the time filter. So if there were no incidents created for a problem within that time frame that problem would be excluded from the list and subsequently that subject wouldn't be available in the subject filter. Is this possible? I have looked into standard calculated attributes but am unsure of how to accomplish what I am trying to with it, or if its even possible. Any help would be appreciated!
Question
Filter dropdown options in explore dashboard filter by only available options in current data set
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Thanks for sharing your detailed use case! Based on your description, it sounds like you want the dropdown filter to dynamically adjust its options based only on the current dataset filtered by time and problem status. Unfortunately, in many standard dashboard tools, dropdown filters tend to show all possible values from the entire dataset by default, rather than adjusting dynamically to filtered data.
A common workaround is to create a calculated attribute or a custom filter that narrows down the subjects based on the filtered problem IDs or incident counts. This often involves some form of conditional logic or joining the filters so that the dropdown only populates subjects tied to unsolved/closed problems within the selected timeframe.
You could try:
Hope this helps point you in the right direction.