How can I create a relative date filter on a datasource?

Question

I know how to create those in widgets, but can I do the same on the datasource level in order to speed things up?Eric

Dhivyabharathi Govindaraj · Answer

Hi Eric, 

Yes, you can apply relative date filters on data source too. For this, 


First  go to “Data filters” icon in dashboard designer.

  


Now “Filters” window will open. Then choose “Add” button to add data filters.

  


In Column combo box choose appropriate date column to apply relative date filters. Now in Formats combo box “Relative Dates” option will display . 
  


Choose relative date option and click “Customize” to open “Relative Date Filter” window. Now in relative date filter window apply your desired filter range just like in widgets level and update the filter. Now you got the filtered data’s in our designer application.

  

For more details, please refer following documentation link https://help.syncfusion.com/dashboard-platform/dashboard-designer/transforming-data/configuring-data-filters . 

Please let me know if you need any further assistance on this.  

Regards, 
Dhivya.

Eric Kok · Answer

Is there a way to use unix timestamps for this as well? Eric

Kavitha Murugesan · Answer

Hi Eric, 
 
We assumed that you are using MySQL as datasource type and also assume your Unix Timestamp datatype as integer.  At first, you have to convert the Unix Timestamp to date format by creating the expression in expression designer like below. 
 
Expression : FROM_UNIXTIME([UnixTimeStampColumn]) 
 
After this, you can apply the relative date filter at widget level as like below. Currently, we don’t have support to apply datasource level filter for expression column.  
 
  
 
If you want to use datasource level filter for Unix Timestamp data, your Unix Timestamp data must be converted into datetime format in your database server level. Otherwise, we don’t have the support to apply datasource level relative date filter for Unix Timestamp data which is displayed number format in our dashboard designer.  
 
  
 
Please let us know, if you need further assistance on this. 
 
Regards, 
Kavitha M.