In a basic configuration, the condition is expressed as :

<FieldName> <Operator> <Value>

For example :

aaValueStartTime > 2018-01-05T00:00:00

Operators

Operators appropriate to Dates and Times can be selected :

filter operator date

Relative date filtering

The special operator “Relative date” allows to select a “date window” / “time frame” that is moving over time relative to the current moment.

When selecting this operator, click the edit icon to define the relative date window :

filter relative date open

Field formatting

Similarly to the number fields, a formatting function can be applied to the date field :

filter format date

This way, the filter condition will be :

<Function>(<FieldName>) <Operator> <Value>

For example :

Year(Date) BETWEEN 2015 AND 2016

Values

Static values

The “Edit values” button can be check/unchecked manually :

filter edit values check-uncheck

When the “Edit values” button is un-checked, a value can be selected from current values in the database :

filter select date values

When the “Edit values” button is checked, a value can also be entered as text :

filter value date

Dynamic filter values using Parameters

Instead of comparing to a static value, it is possible to compare to a dynamic Parameter that will depend on actions inside the Dashboard.

For this, select “Use Parameter” and see the Chapter about Parameters.

filter use Parameter
Last modified: Sep 13, 2021

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment