Formula in structure plugin with -4w not working

rupert.schreder

Hey together,

I'd like to count the in the last 4 weeks created issues via a formula in the JIRA structure plugin

This formula does unfortunately not work:  SUM{If(created >= "-4w";1)}

With absolute date's it is working: SUM{If(created >= DATE("2022-03-01");1)}

But I'd like to avoid absolute dates.. Any ideas?

Regards

Rupert

David Niro

Hello @rupert.schreder ,

David from ALM Works here.  Welcome to the Community!

For this, you will want to use the DAYS_BETWEEN function to calculate the days between your created date and today.  We can then compare this to your 4w, which we need to identify in days.

It should look something like this:

SUM{IF(DAYS_BETWEEN(created,Today())> 28,1)}

Please let me know if it works for you!

Best Regards,
David