Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Use and edit variables
The Variables tab of your SQL mode query lists any available dashboard variables and all the relative date variables that you can use in your query. Learn more about variables.
You won’t see a section for dashboard variables if you don’t have any controls on your dashboard or if you’re creating a chart that isn’t tied to a dashboard.
Similar to the schema browser, selecting a variable from the list adds it to your SQL query, including the special Atlassian Analytics-specific syntax you need to properly use them.
Create more dynamic date options using date and time functions on relative date variables and dashboard variables with a date or datetime data type. Learn more about date and time functions.
Edit variable values
If you’re referencing controls in your query, you can change the values while in the chart editor. This lets you test the query and validate the results when specific values are selected in a control.
To edit variable values for a query:
If you’re not already, select SQL in the query to switch to SQL mode.
Go to the Variables tab.
Select Edit variables () near the Dashboard variables heading. This opens the Edit variable values pop-up.
Change the values of your dashboard variables as needed.
Select Update.
The query automatically reruns to reflect the updated variable values.
Reset variable values
After you’ve tested out different values for your dashboard variables and how they affect your query, you can reset your dashboard variables back to their default values.
To reset your dashboard variables:
If you’re not already, select SQL in the query to switch to SQL mode.
Go to the Variables tab.
Select Edit variables () near the Dashboard variables heading. This opens the Edit variable values pop-up.
Select Reset values.
The query automatically reruns to reflect the default variable values.
Was this helpful?
Still need help?
The Atlassian Community is here for you.