Compare Q4 from the last year with the current year

CESAR DALDOSSO_b2zh72

Hello, I want to collect data from a specific period , which is the Q4 from last year and compare it with the data from this year.

I will do this using status history but cannot find a way of doing 

 

Started at between and including

{CURRENT_CALENDAR_YEAR.START.SUB(1,'year')}

and

 

{CURRENT_CALENDAR_YEAR.END.SUB(1,'year')}

 

With this I have the period of the last year.

How can I obtain the period of the last quarter of the last year ?

one example

I want to compare the average number of issues resolved on the current year (2024)  and compare with the average number of issues resolved within the last quarter of the last year (Q4 2023)  

 

Nayan Pandey

Hi Cesar,

I am Nayan from the Atlassian Analytics team, happy to help!

Can you try using the following relative date variable: 
{CURRENT_CALENDAR_YEAR.START.SUB(15,'month')} and {CURRENT_CALENDAR_YEAR.END.SUB(12,'month')}

This would fetch Q4 for last year.