• Products
  • Documentation
  • Resources

Atlassian Analytics is in open beta

Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.

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 variable 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.

'Variables' tab in a SQL mode query.

Edit variable values

If you’re referencing variable 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:

  1. If you’re not already, select SQL in the query to switch to SQL mode.

  2. Go to the Variables tab.

  3. Select Edit variables () near the Dashboard variables heading. This opens the Edit variable values pop-up.

  4. Change the values of your dashboard variables as needed.

  5. Select Update.

The query automatically reruns to reflect the updated variable values.

'Edit variables' button in the 'Variables' tab of a SQL mode query.

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:

  1. If you’re not already, select SQL in the query to switch to SQL mode.

  2. Go to the Variables tab.

  3. Select Edit variables () near the Dashboard variables heading. This opens the Edit variable values pop-up.

  4. Select Reset values.

The query automatically reruns to reflect the default variable values.

Additional Help