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

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

    Tyson Andrews



      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,