AWS::QuickSight::Analysis RelativeDatesFilter

A RelativeDatesFilter filters relative dates values.

Syntax

To declare this entity in your AWS CloudFormation template, use the following syntax:

JSON

{
  "AnchorDateConfiguration" : AnchorDateConfiguration,
  "Column" : ColumnIdentifier,
  "DefaultFilterControlConfiguration" : DefaultFilterControlConfiguration,
  "ExcludePeriodConfiguration" : ExcludePeriodConfiguration,
  "FilterId" : String,
  "MinimumGranularity" : String,
  "NullOption" : String,
  "ParameterName" : String,
  "RelativeDateType" : String,
  "RelativeDateValue" : Number,
  "TimeGranularity" : String
}

YAML

  AnchorDateConfiguration: 
    AnchorDateConfiguration
  Column: 
    ColumnIdentifier
  DefaultFilterControlConfiguration: 
    DefaultFilterControlConfiguration
  ExcludePeriodConfiguration: 
    ExcludePeriodConfiguration
  FilterId: String
  MinimumGranularity: String
  NullOption: String
  ParameterName: String
  RelativeDateType: String
  RelativeDateValue: Number
  TimeGranularity: 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

DefaultFilterControlConfiguration

The default configurations for the associated controls. This applies only for filters that are scoped to multiple sheets.

Required: No

Type: DefaultFilterControlConfiguration

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

Pattern: ^[\w\-]+$

Minimum: 1

Maximum: 512

Update requires: No interruption

MinimumGranularity

The minimum granularity (period granularity) of the relative dates filter.

Required: No

Type: String

Allowed values: YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND | MILLISECOND

Update 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 | NULLS_ONLY | NON_NULLS_ONLY

Update requires: No interruption

ParameterName

The parameter whose value should be used for the filter value.

Required: No

Type: String

Pattern: ^[a-zA-Z0-9]+$

Minimum: 1

Maximum: 2048

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: PREVIOUS | THIS | LAST | NOW | NEXT

Update requires: No interruption

RelativeDateValue

The date value of the filter.

Required: No

Type: Number

Update requires: No interruption

TimeGranularity

The level of time precision that is used to aggregate DateTime values.

Required: Yes

Type: String

Allowed values: YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND | MILLISECOND

Update requires: No interruption