Count of issues with custom date field value between now and 14 days in the future

Hello community,

We have a date custom field called “Impact Date” and I am trying to construct a calculated measure that returns the count of issues for which this date is between today and 14 days in the future.

I have found similar solutions that returns this count between two date custom fields, but not for relative times. Is anyone able to point me in the right direction?

Many thanks in advance!

Welcome to eazyBI community.
You could try using relative date filters as explained here: Date filters

Martins / eazyBI

Thanks Martins!

That seems to have got me a step closer and I can produce this using the time dimension as a row.

I would like to just show this as a number though, ideally using the gauge chart. Is there a way to aggregate the count over 14 days or just show the total?

Thanks again!

In that case, try creating new calculated member “Last 14 days” for the “Time” dimension and select the member in report rows (not expanded)
See examples of calculated members here: Chart Types - Jira Demo - eazyBI
Just open any of the reports and look for calculated member with similar structure (for example “Last 30 days”)

Martins / eazyBI

Ah, that is perfect, thanks Martins!

1 Like