How to Use Relative Date
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.
Parameters That Support Relative Dates
How to Set Relative Dates
Click the three-dot icon in the upper right corner of the parameter input form
Select and configure
Relative date
orRelative date range
from theDefault value
options
When Relative Dates Are Calculated
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.
Notebook
When a user performs the following operations in the parameter input form:
When
Reset parameter values to default values
is performed for the entire formWhen
Reset to default
is performed for individual parameters
Public Link
Since parameters cannot be changed, the relative date feature is not available.
Report
Relative dates can be applied when opening a report by configuring the following settings:
Publish the report with
Allow Parameter Editing
settingEnable
Automatically run
in theOptions
section ofReport settings
Enable
with default parameter values
in theOptions
section ofReport settings
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
Signed Embed
Relative dates can be applied when opening a signed embed by configuring the following settings:
Specify parameters as
Client-side parameters
(do not specify asServer-side parameters
)In the
Client-side parameters
section ofEmbed iframe
specifyUse 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
Frequently Asked Questions
Q: What is the reference date and time for calculating relative dates?
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?