Showing parameter options in Report Builder
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?
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 firstname.lastname@example.org. This will allow us to look at your metadata and ask you additional questions to further assist this matter, thanks!