{{ }}
, Explo will
recognize any text in-between curly brackets in your SQL query as a variable.
Double square brackets [[ ]]
are used for where clauses with variables such
that if there is no variable selected, Explo will ignore the code between the
square brackets.
All variable clauses must be placed inside square brackets.
Example of where clause using a variable in square brackets:
1 = 1
is required here otherwise there
will be an incomplete clause statement if neither filter is configured.
updateExploDashboardVariable
here.
Subtitle
field.
Variable | Description |
---|---|
{{current_period}} | This is the current period of data that will be used as the basis for comparison e.g. Jun 11 - Aug 12 |
{{comparison_period}} | This is the period that the current_period is compared to for calculating the trend e.g. July 9 - Jun 10 |