Creating a custom date bucket for yearly values

[Niranjan Deshpande]

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 

https://confluence.atlassian.com/analyticskb/create-custom-date-buckets-using-a-dropdown-control-1180147025.html

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?

[Agaci Avinas]

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,

You can modify your case statement as per your requirement. 

Regards,

Agaci