How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta?

msinha8 — Mon, 21 Jul 2025 19:04:45 GMT

Hello ,

I have a requirement to configure two dashboard parameters: “No of Days” and “Total Days”.

By default, these parameters should take values 1 and 10 respectively.
At the same time, users should be able to select any value between -100 and 100 from a dropdown.

To implement this, I created a session variable with the following SQL:

SELECT LEVEL - 101 AS days FROM dual CONNECT BY LEVEL <= 201

I then used this session variable as the source for the dashboard presentation variable. However, instead of showing a dropdown, it displays the values as a list.

Could someone please advise on:

How to set default values for these presentation variables (NoOfDays = 1, TotalDays = 10)?
How to configure the dashboard parameters so users can select from a dynamic or static list ranging from -100 to 100, displayed as a dropdown rather than a list?

Is there a recommended way in Incorta to:

Set default values for presentation variables (NoOfDays = 1, TotalDays = 10)
Still allow user selection from a dynamic or static list ranging from -100 to 100?

Any guidance on how to achieve would be greatly appreciated!

Thanks in advance

Re: How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta?

anurag — Tue, 22 Jul 2025 14:37:34 GMT

Can we meet to review this?

Please log a support ticket and request support for a meeting. Or email me to setup this meeting.

Re: How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta?

mritunjay_sinha — Tue, 29 Jul 2025 19:34:48 GMT

Hi Anurag,

Thanks for the update and as per your suggestion, Request #57793 is created.

Regards,

topic How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta? in Dashboards & Analytics Discussions

How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta?

Re: How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta?

Re: How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta?