Custom Time Based Page Filter

Hi community!

I’m using a bar chart to track our software release cycles and each ticket has a “Release Start Date”. As the months go on, the bar chart gets larger and larger because old releases are shown. I’d like to be able to add a page filter to show “all release tickets whose Release Start Date is in this month”, or “all release tickets whose Release Start Date is in this month”. Using the default Time dimension, I think that it is actually using the “Created Date”. Does anyone know how to use a custom field date instead?

I’ve been trying various different new calculated members but can’t seem to figure it out. Thank you!

Hi @Andrew_Bui,

The measures link together different dimensions, including Time.
The measure “Issues created” is related to issue creation date, the measure “Issues resolved” is related to issue resolution date.
You might select to import that date customfield as a measure in the import options.
Please read more about that here - Jira custom fields.

That would create a new measure “Issues with Release Start Date”.

You might then use this measure to see the issues that had their “Release Start Date” within the displayed Time period.

The problem of the report getting long and displaying past long forgotten could be handled by using Page filter to only show recent periods or by selecting some calculated members like “Last 12 months” in the Time dimension.

Regards,
Oskars / support@eazyBI.com