For this second Query, we want to change the date range to be the previous week instead of the current week. In this example, we create a chart to compare the issues created this week to the previous week’s using the Atlassian Data Lake.Ĭreate a query to get the number of issues created in the current week:įrom the Jira issue table, add the Created at and Issue key columns to the “Columns” section.Ĭhange the aggregation of the “Created at” column to Week.Īdd the Created at column to the “Filters” section of the query and use the current week filter operator.Ĭreate a copy of Query 1. This article has several examples of how relative date variables can be used within Atlassian Analytics.

Relative date variables can be used as parts of other variables, in your queries, in a Visual SQL step, and even in chart titles. This convenient variable eliminates the manual process of updating a date value over time as it dynamically updates with the correct date according to the variable selected. Relative date variables allow you to generate a custom, dynamic date that can be used anywhere you would enter a date value.

How to use confluence to create a date