For program burndown metrics we are required to link 4 different story "types" to their applicable epics. We do this by using a unique Jira field that is populated with the below identifiers on the stories and using epic link to define the hierarchy
I have been able to build the below wiki markup formula that flags the issues when they are found. What I would like is to show the inverse of the below formula and pull a graphic together that shows what stories are missing from the epic.
Values {
// Displays values on rollup
// Searches for FS
IF (SEARCH ( WorkItemType; "A (Write FS)") = 1) : "{panel:bgColor=blue}{color:white}FS{color:blue}{color}{panel}"
//Searches for TS
ELSE IF (SEARCH ( WorkItemType; "B (Write TS)") = 1) : "{panel:bgColor=blue}{color:white}TS{color:blue}{color}{panel}"
//Searches for CUT
ELSE IF (SEARCH ( WorkItemType; "C (CUT)") = 1): "{panel:bgColor=blue}{color:white}CUT{color:blue}{color}{panel}"
//Searches for FUT)
ELSE IF (SEARCH ( WorkItemType; "D (FUT)") = 1) : "{panel:bgColor=blue}{color:white}FUT{color:blue}{color}{panel}"
}