Forum Discussion

saudansari's avatar
saudansari
Helper II
2 years ago
Solved

Conditional Formatting for Matrix Visual for HH:MM:SS Format

Hi,  I have a Matrix visual with Average in HH:MM: SS format and I need to get the conditional formatting, however, there is no fixed range. Needs to format similar to the Gradient format where th...
  • saudansari's avatar
    2 years ago

    I was able to resolve this by converting the HH:MM: SS average to Numeric Average and then Applying the Conditional formatting

    NumericAHT =
    AVERAGE(support__cw_ops_manage_case_merge_temp[FormattedAHT])