Set default datetime as Now

Database Support
#1

Hello Helical Insight,

I am using Helical Insight 4.0 to connect to MySQL database. I have a dashboard on which I want to show the data as on the current date. I understand a filter can be added but the value of the filter should always be current date i.e. it should be relative. How can this be done?

Thanks,
Snow.

#2

Hello Snow,

Helical Insight has the option to use custom values as filter values. You can use various database functions to return the value for the filter. In order to use the current time as the default, follow the below given steps:

  1. Open the report in Edit mode.
  2. Add the date filter. If already added, edit the date filter. Select the condition as required. In values, put the database function NOW() as shown in the image below:

image

Please note: the database function for getting the current datetime may differ from database to database. Please refer documentation for the database that you are using in order to get the correct function to be used.

Thanks,
Helical Insight.