1 Reply Latest reply: Oct 11, 2018 1:49 PM by Stefan Wühl RSS

    Expression Query

    Simbai Mhuka
      DateAvailabilityStatusVendorTechID
      1/01/20180.99BHuawei2GA0001
      2/02/20180.98ASamsung3GA0002
      25/01/20180.999BHuawei3GA0003
      4/04/20180.97AHuawei2GA0004
      7/04/20180.975ASamsung2GA0005
      25/04/20180.99BSamsung2GA0006

       

      Hie Guys. I would like to write an expression that will enable me to  count the number of 'ID's by 'Tech' and 'Vendor' which satisfy the condition that Count (Status = 'A' ) => 14 per month.     

       

      Kindly Assist!!!

       

      Thank you.

        • Re: Expression Query
          Stefan Wühl

          Seems like you want to group your results by Tech and Vendor, so create a chart with two dimensions, Tech and Vendor.

          Then use as expression:

           

          =Sum( Aggr( If(Count({<Status = {'A'}>} Status) >= 14, 1,0), Tech, Vendor, ID))

            • This reply has been hidden. This can happen if the message has been hidden by a moderator, or has been reported as abusive.