How to Use Relative Date
How to access the latest date data using parameters
Last updated
Was this helpful?
How to access the latest date data using parameters
By setting default values for "Date Input" or "Date Range" parameters, you can easily set relative dates such as "today," "yesterday," and "last week" to parameters.
Click the three-dot icon in the upper right corner of the parameter input form
Select and configure Relative date or Relative date range from the Default value options
Relative date calculations are performed when the parameter value is changed to the default value. The timing when parameter values are changed to default values for each feature is shown below.
When a user performs the following operations in the parameter input form:
When Reset parameter values to default values is performed for the entire form
When Reset to default is performed for individual parameters
Since notebook parameter changes are shared with other users in real-time, changes to default values require explicit user action. Relative date calculations cannot be performed when opening a notebook.
Since parameters cannot be changed, the relative date feature is not available.
Relative dates can be applied when opening a report by configuring the following settings:
Select Interactive report in the Report type
Select Enable automatically run on load and With defalut parameter values in the options
If "with default parameter values" is not enabled, parameter values will be the values at the time the report was published
Operations in the parameter input form are the same as in the notebook case
Report parameter changes are not shared with other users.
Relative dates can be applied when opening a signed embed by configuring the following settings:
Specify parameters as Client-side parameters (do not specify as Server-side parameters)
In the Client-side parameters section of Embed iframe specify Use the default value as the initial value
This requires changes to the script that generates the signed embed
If Use the default value as the initial value is not enabled, parameter values will be the values at the time the signed embed was published
If parameters are specified as Server-side parameters, the relative date feature is not available, and relative date calculation processing must be performed when specifying dates on the server side.
Operations in the parameter input form are the same as in the notebook case
However, if the input form is hidden, it will not be subject to default value reset processing, so relative date calculations will not be performed
Signed embed parameter changes are not shared with other users.
A: Relative dates are calculated based on the current time in the browser. Since the timezone follows the browser settings, the calculated relative dates may differ even at the same time if the timezone is different.
Last updated
Was this helpful?
Was this helpful?