3 Replies Latest reply on Oct 26, 2018 9:31 AM by Deepak Rai

    IF 'status' THEN Countd(ID) Mixed Aggregation Issue

    Tyson Andrews

      Hello,

       

      I need a sum of of the countd(positionID) when filled and one countd(positionID) when open.

       

      Right now i have distinct values  buildingID, Open positions, filled positions, then a stacked bar of the two open and filled values. But this isnt getting me a count of all ID's not distinct, and I need it to remain one stacked bar.

       

       

       

      The problem is I lose my one stacked bar if I toss in position status.

       

      Is there a fixed LOD that can work with this? I tried {INCLUDE  [Position ID] : IFNULL(SUM(IF [Position Status] = 'Filled' then 1 END),0)} but it gave me the same results.

       

      Thank you,

      -Tyson