Hide visual based on date range

Q&A
,
1

We are using rules to dynamically hide a visual based on a parameter, but I’ve hit a roadblock.

I want to hide a visual if the parameter “startDate” is less than 90 days from today. When trying to setup the rule, I can’t choose the date parameters. Any ideas on a work around?

2

I assume you have followed the steps in this document, Conditional rules - Amazon QuickSight. Could you share the definition of “startDate”?

3

Hi @carysylvester
looks like a date parameter based rule isnt possible right now.
BR

4

startDate is a parameter with a data type of Date

5

Unfortunately, that’s what I found too. I was trying to be creative with controls and default parameter values, but no luck so far

6

But even if, you can’t use calculation “less then today-90”

7

It is a limitation that you can’t use the date type for the parameter. One workaround is that you can define a parameter with String type referring to a calculated column in a dataset(table). The calculated column has two values(Yes, No) When startDate is older than 90 days, set it to Yes, otherwise No.

8

Thanks Xing. I can’t figure out how to make the parameter refer to a calculated field on a dataset - it will only let me default to an actual column. Any tips?

9

Here is documentation that you can evaluate and follow., Adding calculated fields - Amazon QuickSight