Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count of Status

Hi All. I have a requirement to calculate the number of time a submission number has toggled between different teams for two scenarios.  Data below: I need to derive two columns based on the...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous See attached, Table (24). Toggle Index totals to 5, that's the overall toggle. Toggle Index Team has four 1's for Prereview and one 1 for IRB Review. Is this what you are looking for?

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous I need to understand your expected results. 

 

You state:

Eg : For the first submission number, for Pre-Review type : count is 4

Cell U3, U4 (U 3 and U4 - same team ) to U5 = 1 time (IRB Staff to Study Team)

U5 to U 6 = 1 time ( Study team to IRB Staff)

U6 to U7 = 1 time (IRB Staff to Study Team)

U7 to U8  = 1 time ( Study team to IRB Staff)

Total 4 times

 

4 is the number that Toggled returns as you show and is highlighted. So, first, is Toggled flagging the right rows or not?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Greg_Deckler 

Thanks for getting into details.

Yes, the above is true for "Pre-Review". The toggled count=4 should be against "Pre- Review".

Same for "IRB Preview"