7 Replies Latest reply: Nov 9, 2016 7:09 AM by JUAN villalva RSS

    count elements that pass multiple conditions on the same field

    JUAN villalva

      Hi

       

      I want to count devices that has multiple conditions on the same field as follow:

       

      Input Table

       

       

      device idstatus
      1103
      11
      1102
      1114
      2102
      2103
      2114
      2117
      3103
      3114
      4100
      4102

       

      Then I want the following KPI's

       

        

      conditiondevices
      status 1033
      status 103 and status 11
      status 103 and status 114 and no status 1

      1

       

       

       

      I tried something like this without any success for the first KPI:

       

      count( {<status={'103'}>} * {<status={'1'}>} distinct device_id)

       

       

      Thanks a lot!