Cascading parameters

Hi,

Is there any way to create cascading parameters so that one parameter is dependent on another?

 

Thanks!

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Madeline Perez !

    We do have two approaches for supporting this use case.

    The first approach would require you to run the report twice. You would select an input for the first parameter, run the report, and then you will see a list of valid selections for the second parameter and can rerun the report again with the desired selection. Here's an example report utilizing this logic. Feel free to follow along with the logic by clicking on view details --> SQL ---> check box "Show parameter template code"

    The second approach is to select an input for the first parameter and then include a report filter in the report, so that after the parameter value is inputted the filter will adjust as appropriate and allow the user to filter the data as desired. You can see an example report utilizing this logic here

    Like
Like2 Follow
  • 2 Likes
  • 5 mths agoLast active
  • 1Replies
  • 219Views
  • 3 Following