1 Reply Latest reply on Oct 9, 2019 5:26 PM by Hari Ankem Branched from an earlier discussion.

    Re: Calculation

    Shakeela  devi

      Next question for the same situation.

       

      COUNT(IF [Priority-value] = 'Critical' then [Problem Investigation Id] END) - this calculation applies, if i want to calculate the Priority risk value, one by one.

      what if i want to have overall count ?

       

      i know measure is available for the total count but its excluding certain domain. for example,

       

      I need a breakdown by domain and for all the priority regardless they have data or not.

      which means,

      my domain split should be

       

      compute = 45

      web - 5

      database = 0

       

      but instead its ignoring one of the domain. how can i do this ?

       

      btw there is no specific domain call domain, i have created a group based on assignment group. you may use the same data to help me on this.