Problem to create table based on requirements

Questions & Answers
1

Hi there…
I would like to create a Table which will required the following requirements:

  • Issue Key
  • Created Date
  • Target End Date
  • Measure in % of issues completed under the epic
  • Assignee
  • Team

It also requires to be filtered by a specific component which only appears in epic issues (a specific client) and to be able to view only those that are in To Do and In Progress categories.

So far, I have selected “Project” in “Pages” and used “Issue” in “Rows”.

In Measures, I have selected the following:

  • Issue key
  • Issue created date
  • Issue Target end
  • Issue resolved %
  • Issue status
  • Issue assignee
  • Issue Team

As long as I don’t try to filter with the component, I still get the appropriate Issue resolved % calculation in the table… But if I add “Component” to “Pages” and select the client I want to view the information for, the “Issue resolved %” column in my table breaks (as the component is only in epics)…

Without Component:

image
image1583×336 21.2 KB

With client component:

image
image1562×420 26.7 KB

HELP!

2

Hi, @HRivest

Thank you for your use case.

For children to have the Epic Component, please consider use the JavaScripted custom field to inherit the Component. Since the Component is a multi-select field; there will be limitations.

Here is the information about inherited fields ( Account-specific calculated field and Global calculated field): Epic level custom field

My collage Zane explains how to create a Global calculated field here:

Kindly,
Ilze