Parameter at Dataset Level

Q&A
,
1

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

2

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

image
image618×522 29.4 KB

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.

3

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

4

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!

5

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

6

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.

7

Could you please mention the steps to do so ?

8

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

image
image719×433 22.9 KB

  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)

image
image302×269 5.35 KB

Analysis Parameter Control

image
image249×438 10.5 KB

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

image
image244×667 17 KB

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

image
image661×268 7.22 KB

9

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

10

Hi @bhumika18s

Yes. Thats right.