Summary of start and end dates

[Jagdev Panesar]

I have an number of Jira stories in a filter.

They have different start and end dates (due date, more specifically).

I would like a one-line display of the minimum start date with maximum due date in Confluence.

e.g. as in these 4 attributes:

• Filter name, number of stories, earliest start date, latest due date

N,B. I am not able to create Epics for this work.

I have tried:

• Creating a plan based on the filter
• Defining a view with that sort-of-summary
• Inserting a link to that view in Confluence

However, it then shows a big rectangular box with the plan embedded (or the other ways of representing links, when not much information is shown).

Ideas welcome, thanks.

[Karan Sachdev]

Hey @Jagdev Panesar

Welcome to Atlassian Community!

You can use an automation rule in Jira to find the min and max dates from the issues in your filter.

Store these dates in separate custom fields, and display it in the filter as columns. If you're using the Jira issues macro in Confluence, this can be displayed in Confluence page also.

The rule should be something like below. You can modify the trigger and add conditions if required.

Smart values:

{{lookupIssues.Start date.min}}

{{lookupIssues.Due date.max}}

Thanks!