Create a Parameter Dropdown that matches a filtered variable in a table

Question & Answer
, , ,
1

Hi, I currently have a table with a variety of filtered variables inside it. From applying these filters, another variable I have is ID, and I would like to create a drop down list parameter that matches the filtered ID column in my table. I would like to use this parameter to then make plots for specific IDs in the table, and allow the user to pick which ID to make the plots from.

Any help is greatly appreciated!

1 Like
2

Hello @ZacB

I believe you will want to use cascading filters for this:

3

Hi @duncan,

I have been trying to implement this but I have had no luck as of yet. If you could provide some more specific instructions for this it would be very helpful to me! Let me know if you need some extra information or context.

4

Hello @ZacB

What are the specific areas that you are running into issues on setting this up?

The basic overview is you will want to create parameters for each of your fields then create controls that are linked to the fields in your dataset. In the same menu when you create the control, at the bottom you will see a box that ask if you want to use “relevant values”. When you check that box you can select which other control the current one you’re building should respond to.

5

Hi @duncan,

The issues I was having in setting this up with the select relevant values only were that I had parameters that were text fields which acted as greater than or equal to conditions which couldn’t be recognised in that section. I’ve tried a lot of things in the last week to make this work but I finally found an implementation I liked yesterday. Instead of using drop down parameters and filter controls with the cascading filters, I got the cascading filters to work by implementing them in a separate table that dynamically updates the IDs that I want instead, and then applying the cascading filters which worked like I want it to! Thanks so much for the help @duncan, very much appreciated!

1 Like
6

Hey @ZacB

I’m glad you were able to get this to work and it sounds like a great solution. I’ll definitely keep this in mind for some of my future dashboards!