Time Filter

Introduction

Functions

To filter time fields in the dashboard: Date＆Time in forms, Created Time and Updated Time of system fields.

Application Scenarios

The data needs to be filtered out according to a certain time range. For example, students born later than a certain time need to be filtered out to determine that whether they meet the age requirement for entry.

Preview

Setting Procedure

Adding Filter Components

Visit a dashboard and go to the editing page:

Then add a filter component above Order Details:

Setting a Time Filter

Select the chart you want to filter, such as Order Details, select the Date＆Time field Order Date. Filter condition includes:

... equals ...
... not equal to ...
... is greater than or equal to ...
... is less than or equal to ...
... is between ...
... is within ...
is empty
is not empty

Time Filter Style

When the filtering relationship of Date＆Time is is between, changing the size of the component can change the style of the filter component. As shown in the following figure:

Demonstration

1. On PC

2. On Mobile

Time Filter Instruction

Fixed Filter

Filter Conditions	Filter Instructions
... equals ...	Choose a fixed time
... not equal to ...	Choose a fixed time
... is greater than or equal to ...	Choose a fixed time
... is less than or equal to ...	Choose a fixed time
... is between ...	Set a fixed range, set a fixed time as Start time, and a fixed time as End time.
is empty	There is no data field, thus no data will be displayed.
is not empty	There are data fields, thus certain data will be displayed.

Dynamic Filter

Type	Dynamic Value
Fixed Dynamic	Today Yesterday Tomorrow This Week Last Week Next Week This Month Last Month next Month This Quarter Last Quarter Next Quarter This Year Last Year Next Year
Custom	Time state	Quantity	Dynamic Value
	Current	1	Days Week Month Quarter Year
	Past	1～99	Days Week Month Quarter Year
	Future	1～99	Days Week Month Quarter Year

Note:
1) After setting the dynamic time, a time range will be given. If this time range is set as Start Time, the start point of the time range will be the actual Start Time. If this time range is set as End Time, the end point of the time range will be the actual End Time.
2) Past 1 Week ≠ Past 7 Days. For example, Current is the 30th week, Past 1 Week refers to the 29th week, Past 2 Week refer to the 28th week, the same goes for Past and Future n Week/Month.