TimeRangeFilter - Amazon QuickSight
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

TimeRangeFilter

A TimeRangeFilter filters values that are between two specified values.

Contents

Note

In the following list, the required parameters are described first.

Column

The column that the filter is applied to.

Type: ColumnIdentifier object

Required: Yes

FilterId

An identifier that uniquely identifies a filter within a dashboard, analysis, or template.

Type: String

Length Constraints: Minimum length of 1. Maximum length of 512.

Pattern: [\w\-]+

Required: Yes

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.

Type: String

Valid Values: ALL_VALUES | NULLS_ONLY | NON_NULLS_ONLY

Required: Yes

DefaultFilterControlConfiguration

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

Type: DefaultFilterControlConfiguration object

Required: No

ExcludePeriodConfiguration

The exclude period of the time range filter.

Type: ExcludePeriodConfiguration object

Required: No

IncludeMaximum

Determines whether the maximum value in the filter value range should be included in the filtered results.

Type: Boolean

Required: No

IncludeMinimum

Determines whether the minimum value in the filter value range should be included in the filtered results.

Type: Boolean

Required: No

RangeMaximumValue

The maximum value for the filter value range.

Type: TimeRangeFilterValue object

Required: No

RangeMinimumValue

The minimum value for the filter value range.

Type: TimeRangeFilterValue object

Required: No

TimeGranularity

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

Type: String

Valid Values: YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND | MILLISECOND

Required: No

See Also

For more information about using this API in one of the language-specific Amazon SDKs, see the following: