AWS::QuickSight::Dashboard RelativeDatesFilter
A RelativeDatesFilter filters relative dates values.
Syntax
To declare this entity in your Amazon CloudFormation template, use the following syntax:
JSON
{ "AnchorDateConfiguration" :AnchorDateConfiguration, "Column" :ColumnIdentifier, "ExcludePeriodConfiguration" :ExcludePeriodConfiguration, "FilterId" :String, "MinimumGranularity" :String, "NullOption" :String, "ParameterName" :String, "RelativeDateType" :String, "RelativeDateValue" :Double, "TimeGranularity" :String}
YAML
AnchorDateConfiguration:AnchorDateConfigurationColumn:ColumnIdentifierExcludePeriodConfiguration:ExcludePeriodConfigurationFilterId:StringMinimumGranularity:StringNullOption:StringParameterName:StringRelativeDateType:StringRelativeDateValue:DoubleTimeGranularity:String
Properties
AnchorDateConfiguration-
The date configuration of the filter.
Required: Yes
Type: AnchorDateConfiguration
Update requires: No interruption
Column-
The column that the filter is applied to.
Required: Yes
Type: ColumnIdentifier
Update requires: No interruption
ExcludePeriodConfiguration-
The configuration for the exclude period of the filter.
Required: No
Type: ExcludePeriodConfiguration
Update requires: No interruption
FilterId-
An identifier that uniquely identifies a filter within a dashboard, analysis, or template.
Required: Yes
Type: String
Minimum:
1Maximum:
512Pattern:
[\w\-]+Update requires: No interruption
MinimumGranularity-
The minimum granularity (period granularity) of the relative dates filter.
Required: No
Type: String
Allowed values:
DAY | HOUR | MILLISECOND | MINUTE | MONTH | QUARTER | SECOND | WEEK | YEARUpdate requires: No interruption
NullOption-
This option determines how null values should be treated when filtering data.
-
ALL_VALUES: Include null values in filtered results. -
NULLS_ONLY: Only include null values in filtered results. -
NON_NULLS_ONLY: Exclude null values from filtered results.
Required: Yes
Type: String
Allowed values:
ALL_VALUES | NON_NULLS_ONLY | NULLS_ONLYUpdate requires: No interruption
-
ParameterName-
The parameter whose value should be used for the filter value.
Required: No
Type: String
Minimum:
1Maximum:
2048Pattern:
^[a-zA-Z0-9]+$Update requires: No interruption
RelativeDateType-
The range date type of the filter. Choose one of the options below:
-
PREVIOUS -
THIS -
LAST -
NOW -
NEXT
Required: Yes
Type: String
Allowed values:
LAST | NEXT | NOW | PREVIOUS | THISUpdate requires: No interruption
-
RelativeDateValue-
The date value of the filter.
Required: No
Type: Double
Update requires: No interruption
TimeGranularity-
The level of time precision that is used to aggregate
DateTimevalues.Required: Yes
Type: String
Allowed values:
DAY | HOUR | MILLISECOND | MINUTE | MONTH | QUARTER | SECOND | WEEK | YEARUpdate requires: No interruption