Forum Discussion

dwightman2176's avatar
dwightman2176
Frequent Visitor
2 years ago
Solved

Create and populate a Calculated Column with MAX value from child tickets

Hello!   I'm trying to calculate an availability % based on our unique incidents. To give that some context, when we log a major incident it could impact several areas/products within the business....
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    dwightman2176,

     

    Try this calculated column:

     

    MAX Downtime Per Incident = 
VAR vIssueKey = Issues[ISSUE_KEY]
VAR vTable =
    FILTER ( Issues, Issues[ISSUE_PARENT_ISSUE_KEY] = vIssueKey )
VAR vResult =
    MAXX ( vTable, Issues[Downtime] )
RETURN
    vResult