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.
Sort and limit the rows of your visual mode query
After you add one or more columns to your visual mode query, you can change how the query’s results are sorted and how many rows to the query should return.
Sort rows
Your query is automatically sorted by the order you’ve added your columns.
Select Sort rows by below the “Columns” section to update the applied sort in your visual mode query.
To add a sort block:
Select +Add sort.
Select the column to sort by.
Select the sort direction (Asc for ascending or Desc for descending).
To remove a sort block, select the X within its block.
To edit a sort block:
Select the column name to choose a different column
Select Asc/Desc to change the sort direction
You can only sort by columns you’ve added to the “Columns” section of your query.
Limit rows
Set the number of rows returned from your query.
Atlassian Analytics queries all rows in your data source to calculate your result set.
The rows returned from that result set are limited to the number you provide for the Row limit.
To improve performance while creating and testing your chart, the row limit for the returned results of your query is set to 1,000 by default. When you’re finished testing, you may want to increase this limit to ensure that your chart results are not truncated by this limit.
The maximum row limit for queries is 1,000,000.
The maximum row limit for each chart type varies, so you may need to use a “Limit rows” step later in your Visual SQL. Learn more about the data limits for charts.
Was this helpful?
Still need help?
The Atlassian Community is here for you.