1 Reply Latest reply on Apr 3, 2018 1:51 PM by Sarah Zaleski

    Count marked status

    Sarah  Zaleski

      Trying to count the number of times 1 appears in each column. total each column.  examples using WaitingProposal  (columns shown in sheet 2)

      calculating the number of times waitingProposal shows up in the column data with regards to the filters

      waitingProposal = 50 should be?

      These are the things I have tried: shown in sheet 3

      NumberIds = {FIXED [C Id (Workitem)]:COUNTD([C Id (Workitem)])}

      Count Weeks = Window_Count(Count([WaitingProposal]))

      NumberIdswp = {FIXED [C Status (Workitem)] : COUNTD([C Status (Workitem)] == 'waitingProposal')}

      Sumwp = SUM( INT ( [C Status (Workitem)] = "waitingProposal" ) )

      Total = TOTAL(COUNTD([WaitingProposal]))

       

      WaitingProposal = IF ( [C Status (Workitem)] == 'waitingProposal' AND [Max Update] = true ) THEN 1 ELSE 0 END /* used this to mark 1 or 0 for counting

       

      countwp = sum ( [WaitingProposal] )

      sumwptotal = Total(SUM ( INT ( [C Status (Workitem)] = "waitingProposal" ) ))