Showing parameter options in Report Builder

Hello,

I added dynamic parameters via a form in my SQL query, but I'm unsure of how to get a dropdown with the parameters in the Report Builder. Do I have to write HTML for it?

 

Thanks,

Niranjan

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Niranjan, thanks for reaching out!! One thing to note: you cannot see the parameter forms in the Report Builder. Instead, add your parameter code to one or more queries and then click "View" in the report header. Assuming the parameter form code is valid, you should see the form added to the top of your report. You can also learn more about parameters here https://mode.com/help/articles/parameters/#top

    If you run into any issues using parameters, please feel free to open a ticket with our success team via in-product chat or you can send an email directly to success@modeanalytics.com. This will allow us to look at your metadata and ask you additional questions to further assist this matter, thanks!

    Like
  • Great, will do. Thank you! One more question, the name, value pair in the forms are not populated using unique values from the dataset right? I'll need to SELECT distinct just for that

    Like
  • Yes, that's correct!

    Like
Like Follow
  • 2 mths agoLast active
  • 3Replies
  • 23Views
  • 2 Following