How to update data parameters based on the value of another parameter

Question & Answer
, ,
1

I have a dataset that is looking at Month Over Month changes. The base parameter is Month Year (i.e. August 2025, April 2025, etc.). That Month Year selection is generated from a table that looks like the following:

image
image391×172 13 KB

I am using startdate and first_of_month to calculate the previous month’s value, and first_of_month and enddate to calculate the current month’s value.

I have the startdate, firstofmonth, and enddate parameters set to have a dynamic default value using the month_year as the user name column and the group name column, and the column itself as the column for the default value.

image
image513×277 13.2 KB

However, when I make a new selection on the Month Year dropdown, the dates are startdate, firstofmonth, and enddate do not update. The stay at the default values I set on the main parameter page:

image
image502×260 12 KB

How do I get the dates to automatically update based on the selection made on the month_year column?

2

Hi @hcorbett,
Unfortunately the dynamic default parameter feature is structured around dynamically setting parameters based on users, not other parameters.
Parameters interacting with each other are fairly limited to showing relevant values based on each other.

This would be a nice feature addition to parameters so I’ll mark this as a feature request to promote visibility to the support team.

I’ll include some additional information below regarding dynamic default parameters and the best way to utilize:

3

Thank you so much! The parameters I’m trying to change are dates so sadly using relevant values doesn’t work in my case.

Hopefully we can get this feature added in the future.

1 Like