How to change the parameter controls values based on some condition

Question & Answer
2

Hello @Harsheena , I think your solution here is going to be similar to the solution I suggested for the other topic you posted in the community.

I would try a similar functionality where you use the Start Date and End Date parameters to set your specific period within the dataset via a calculated field and then implement a similar filter on that calculated field by using rolling date to exclude nulls.

Here is the calculated field I suggest to try and get this to work:

ifelse(
addDateTime(7, 'HH', ${STARTTIME}) <= {Date} AND {Date} <= addDateTime(-5, 'HH', ${ENDTIME}),{Date}, NULL
)

Let me know if this helps! Good luck!