Creating a custom date bucket for yearly values

Niranjan Deshpande February 15, 2024

To cater to reporting needs for a financial year (starting in the month of July and ending in the month of June the next year), I am looking to build a custom date bucket picket in Atlassian Analytics. Something to the likes of


but with the options such that the drop down will contain these values:

1 July 2019 - 30th June 2020, and so on to current year.


Is it possible using the JQL / visual builder in Atlassian Analtics?

1 answer

0 votes
Agaci Avinas
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 19, 2024

Hi @Niranjan Deshpande ,

Thank you for reaching Atlassian Analytics support. Sure, yes you can set the financial year for the year filter in the Date Bucket. You can follow the same steps in the document which you have specified. You just need to modify the logic for the Year in the case statement to show next year range for month greater than or equal to 07 (July)

Please find the below example,

Case when {DATE_BUCKET_DROPDOWN}="year" Then( Case when strftime("%m", "Created") >= "07" Then Concat(strftime("%Y","Created"),' - ' , strftime("%Y","Created")+1) Else Concat(strftime("%Y","Created") - 1,' - ' , strftime("%Y","Created")) END) Else "Created" END 

So, with this statement when you select year the values would look like below,

Screenshot 2024-02-19 at 4.04.33 PM.png

You can modify your case statement as per your requirement. 



Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events