The Time Filter Component can filter the date field data in other components, such as filtering data by year-month, year-quarter, and a specific date interval.
The basic data involved in components typically spans over a long period and filtering data over a long timespan may result in downtime. In addition, data on some dates is meaningless for a query. In this case, you can use the Set Optional Interval function when making time filter components to limit users' selection of time range. Users can also set the time-filtering condition to a dynamic time compared to the current time, which can change with the date.
The Time Filter Component can only filter date-type fields.
There are seven time filter components, namely Year Filter Component, Year-Month Filter Component, Year-Quarter Filter Component, Date Filter Component, Date Panel Filter Component, Date Interval Filter Component, and Year-Month Interval Filter Component, as shown in the following figure
You can use the sample data: Regional Data Analysis.xlsx.
This section uses the Year Filter Component and the Regional Data Analysis dataset to illustrate how to filter data by year and limit users to only filter the data of 2014 and 2015.
Create a component, drag the Time of Contract field into Dimension and the Received Payment field into Indicator, and set Time of Contract to be grouped by Year-Month, as shown in the following figure.
Create a dashboard, drag the prepared component to the dashboard, and add a Year Filter Component, as shown in the following figure.
Go to the editing interface of the filter component, drag Time of Contract into Field, tick Set Optional Interval, and set the interval to 2014-2015, as shown in the following figure.
The component displays data of 2014 by default and only 2014 and 2015 can be chosen as the filtering condition. Other year options are grayed and cannot be chosen, as shown in the following figure.
Drag a Time Filter Component into a dashboard and drag Time of Contract of the Regional Data Analysis table into Field.
Choose 2014-01.
Display data of which the Time of Contract is 2014-01-XX.
Only set the Year to 2014.
Display all data of which the Time of Contract is 2014-XX-XX.
Year-Quarter Filter Component
Choose 2014 and Second Quarter.
Display data of which the Time of Contract is between 2014-04 and 2014-06.
Date Filter Component
Choose 2014-10-30.
Display data of which the Time of Contract is 2014-10-30.
Date Panel Filter Component
Date Interval Filter Component
Choose 2015-09-01 and 2015-09-10.
Display data of which the Time of Contract is between 2015-09-01 and 2015-09-10.
Only set the start time to 2015-09-01.
Display all data of which the Time of Contract is equal to or later than 2015-09-01.
Only set the end time to 2015-09-10.
Display all data of which the Time of Contract is equal to or earlier than 2015-09-10.
Year-Month Interval Filter Component
Choose 2013-01 and 2013-07.
Display all data of which the Time of Contract is between 2013-01 and 2013-07.
Only set the start year to 2013.
Display all data of which the Time of Contract is equal to or later than 2013-01-01.
Only set the end year to 2013.
Display all data of which the Time of Contract is equal to or earlier than 2013-01-01.
You can set the current time as the filtering condition. For example, when using the Date Filter Component, you can select Today as the filtering condition, as shown in the following figure.
The default current time of the Date Filter Component, Date Panel Filter Component, and Date Interval Filter Component is Today.
The default current time of the Year Filter Component is Current Year.
The default current time of the Year-Month Filter Component, and Year-Month Interval Filter Component is Current Month.
The default current time of the Year-Quarter Filter Component is Current Quarter.
Users can set the time-filtering condition to a dynamic time compared to the current time, which can change with the date.
For example, if the current date is 2023-12-25, and you want the data of 2023-11-25, you can set the dynamic time as follows and click OK.
The filtering is performed accordingly as the date changes. If the current date turns to 2023-12-28, the data of 2023-11-28 will be displayed.
Time Options of Different Filter Components in Dynamic Time
Year
Year, quarter
Year-Month Filter Component, Year-Month Interval Filter Component
Year, month
Date Filter Component, Date Interval Filter Component, Date Panel Filter Component
Year, quarter, month, week, day, weekday
Weekday Explanation
The Date Filter Component, the Date Interval Filter Component, and the Date Panel Filter Component can be used to get the data of certain weekdays before or after the current time.
By default, all dates except for official holidays are regarded as weekdays in FineBI.
Enterprises can modify the holiday file in %FineBI%\webapps\webroot\WEB-INF\assets\extdata to match their holidays.
Open the holiday file in Notepad, and add or delete holidays as shown in the following figure.
If you are using FineBI released before 2022, download the latest holiday file. Replace the original holiday file in %FineBI%\webapps\webroot\WEB-INF\assets\extdata with the latest one after decompression. If you are using FineBI released after 2022, no processing is required.
1. Only xxxx-xx-xx date format is supported for customizing holidays at the time being, as shown in the above figure. The format of xxxx/xx/xx is not supported.
2. Do not modify the holiday file using Excel, where dates are stored in the format of xxxx-xx-xx automatically after you save the modification, which will cause filtering errors. Using a text editor is advised.
On the editing interface of the Date Filter Component, the Date Panel Filter Component, and the Date Interval Filter Component, you can enable Show Time, which is disabled by default. If it is enabled, users can make detailed filtering by adding hour, minute, and second into the filtering condition.
On the filter component editing interface, tick Show Time to enable it, as shown in the following figure.
The filter component with Show Time enabled is shown in the figure below, and users can filter the data of a specific moment.
For details about customizing the background color, theme color, title text, and others of the filter component, see Setting Filter Component Style in Dashboard Styles.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy