How to group by the date of creation of Epiks (by months) in the Jira Structure?

[serviceonline1@yandex.ru]

Colleagues, good afternoon.

I have a project in Jira. Epiks are displayed in the Structure. I can do simple groupings, for example by Status https://www.screencast.com/t/pNBHG4WSIYv5

We need grouping by the date of creation of Epikov. More precisely, by the months in which they were created. For example:
- March
> Epik 1
> Epik 2
- April
> Epic 3
Etc.

I was told what I need:
- Add transformation https://www.screencast.com/t/Vruir9ymQM 
- Select "Attribute" https://www.screencast.com/t/RnfbQ7yhufj
- Enter the formula https://www.screencast.com/t/iMstEoxJICwF
But, how to write the formula is a question.

[Dionathan Lopes {ALM Works}]

Hello serviceonline1@yandex.ru 

Dionathan with ALM Works here. 

The steps you are following are correct, and you can find more information about transformations here: Link 

Now, you could try using the following code and let me know if it helps:

FORMAT_DATETIME(created, "MMMM")

Looking forward to hearing from you.

Best Regards,
Dionathan

[Dionathan Lopes {ALM Works}]

Hi serviceonline1@yandex.ru 

In this case, please try the following code and let me know how it goes (PS: It only works on the latest version of Structure on-prem (V7.4+)):

FORMAT_DATETIME(history.filter($.changes.any($.field = "status" and $.to = "Closed")).time, "MMMM")

For more information about Formulas, please click here 

If any other questions, let me know.

Best Regards,
Dionathan Lopes
www.almworks.com

[serviceonline1@yandex.ru]

@Dionathan Lopes {ALM Works}Tried. The system writes an error https://www.screencast.com/t/j16nJg4m3ya 

[Dionathan Lopes {ALM Works}]

serviceonline1@yandex.ru 

Please confirm which Structure version you are using. To check that, click Info at the bottom of the right side of your screen.

The last formula provided only works on the latest version of Structure (Versions 7.4 +).

If you are already using version 7.4+, please send us a note to support@almworks.com or contact us through our customer portal: support.almworks.com

Looking forward to hearing from you.

Best Regards,
Dionathan

[serviceonline1@yandex.ru]

@Dionathan Lopes {ALM Works} I have Jira v8.20.2

[Dionathan Lopes {ALM Works}]

serviceonline1@yandex.ru 

Thank you, but you need to confirm the Structure plugin version, not Jira.

By clicking Info at the bottom of the right side of your screen you should see the information. Example:

If any questions, let me know.

Best Regards,
Dionathan

[serviceonline1@yandex.ru]

@Dionathan Lopes {ALM Works}I found out that we have Structure version 7.3.0 installed
How can I solve the problem in this case?

[Dionathan Lopes {ALM Works}]

Thank you serviceonline1@yandex.ru for the confirmation.

In this case, we kindly recommend upgrading your Structure plugin to version 7.4+ or 8 and trying the last suggested code.

In case you need further assistance, please send us a note at support@almworks.com or contact us through our customer portal: support.almworks.com

Best Regards,
Dionathan

[serviceonline1@yandex.ru]

@Dionathan Lopes {ALM Works}Thank you. I will try.

[serviceonline1@yandex.ru]

@Dionathan Lopes {ALM Works} 

Hello.

Asked support to update Jira to version 8.
The formula is displayed correctly https://www.screencast.com/t/DSs1E4OVwZuE
But the formula doesn't group Epics by the month they were completed. Instead it says "No value" https://www.screencast.com/t/PkWtRpCQiC7H

How to solve the problem?

[Dionathan Lopes {ALM Works}]

serviceonline1@yandex.ru 

You would need to make sure that the correct Status is being used in the formula:

FORMAT_DATETIME(history.filter($.changes.any($.field = "status" and $.to = "Closed")).time, "MMMM")

It is using status = Closed, is this the correct one?

Best Regards,
Dionathan

[serviceonline1@yandex.ru]

@Dionathan Lopes {ALM Works} 

I changed the status from Closed to the way it is written in our system. And the formula performed the grouping correctly. Thank you!

Only I had a few remarks when working with these groupings (groupings by the date of completion of the Epik and the date of the creation of the Epik).

The grouping displays months for different years https://www.screencast.com/t/11GOcY9IHjk9
The chronology is broken.

For epics grouped by creation date and end date how do i make level 1 be year and level 2 be month. And they followed each other in chronological order.

Example
- 2021
> January
> February
- 2022
> January
> February

[Dionathan Lopes {ALM Works}]

serviceonline1@yandex.ru 

Thank you for letting me know.

Please send us a note at support@almworks.com or contact us through our customer portal: support.almworks.com, and we will be more than happy to help.

Best Regards,
Dionathan

[serviceonline1@yandex.ru]

@Dionathan Lopes {ALM Works} I managed! Thank you!
And how to make the same grouping but by the date of transfer to the last status "Closed"?
Screenshot: https://www.screencast.com/t/lQxCrPbe