Time Filter

Introduction

Feature Overview

Time Filter can filter Date&Time fields, Created Time fields, and Updated Time fields.

Scenario

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.

Preview

Setup Steps

Adding Filter Components

Visit a dashboard, and go to the editing page:

Then add a Filter component on top of Order Details:

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

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	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.