Parameter at Dataset Level

How to create parameter at dataset level and user will get dropdown to choose the values at the analysis level.

Hi @bhumika18s,
You can add a parameter at the dataset layer by the following steps:

Once completed, head back to your analysis and under the parameters section, you’ll now see your ‘Dataset Parameters’ section at the bottom. To have it sync up with a dropdown, you’ll need to map the Dataset parameter to an Analysis parameter so that it can sync up to one of your controls.

Hi @bhumika18s,
Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

Hi @bhumika18s,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!

Hello, sorry about late respond. When we do dataset parameter we have to pass the default values and only those default values which we have passed will come in the dropdown at the analysis level, once we map the Dataset parameter to to an Analysis Parameter. Is there any way to get all the values of Dataset in the dropdown ?

Thanks!

Bhumika

Hi @bhumika18s

The default value for the parameter in the dataset is mainly to prevent the dataset query from failing. However, you can create a parameter in the Analysis which is independent from the dataset parameter and you map the analysis parameter to the dataset parameter.

So when you select a value in the parameter control the same will be passed to the dataset parameter and used when the query is executed on the dataset.

Could you please mention the steps to do so ?

Hi @bhumika18s

Here’s an example.

  1. I created a Dataset parameter and then used the same in my Custom SQL. There is a default value for the parameter so it will always work

  1. In the analysis I created a Analysis Parameter. I then added a parameter control with values to display a dropdown of values (it could be linked to a dataset as well if you have values available in the dataset)

Analysis Parameter Control

  1. Then linked the Analysis Parameter to Dataset parameter link in the parameters pane.

  1. Now when you select a different value in the analysis dropdown you get the results that match your selection

so, you are able to see all the values (dataset linked ) and not only the values which we have passed as default.

Hi @bhumika18s

Yes. Thats right.