What is a Time Filter?
Time Filter can filter Date&Time fields, Created Time fields, and Updated Time fields.
When to Use a Time Filter?
Scenario Name | Problem Statement | Solution on Jodoo |
Order Period Verification | How to confirm the number of orders within a particular time period for further analysis? | Add a Time Filter in the dashboard to identify orders placed between certain dates. |
What Does It Look Like?
How to Set up?
Step 1 Adding Filter Components
Visit a dashboard, and go to the editing page:
Then add a Filter component on top of Order Details:
Step 2 Setting a Time Filter
Tick the chart you want to filter (Here, tick Order Details), and select the Date＆Time field (the Order Date field) where you want to add the filter.
1. The time formats include:
YYYY-MM
YYYY-MM-DD
YYYY-MM-DD HH:MM
YYYY-MM-DD HH:MM:SS
2. The filtering relationships include:
... 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
Step 3 Choosing a Time Filter Style
If the filtering relationship of Date＆Time is set as is between, changing the size of the component can also change the style of the component:
Demonstration
1. On PC
2. On Mobile
Time Filter Instructions
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 |
|
|
|
Custom | Time state | Quantity | Dynamic Value |
| Current | 1 |
|
| Past | 1～99 |
|
| Future | 1～99 |
|
Notes:
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 endpoint 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 refers to the 28th week, the same goes for Past and Future n Week/Month.
I have finished reading. 🏆
👉I can't wait to Try for myself.
👉I need more HELP in Discord Forum.