Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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 OK, so Overall Toggle count should be 4 then? Is that correct?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler 

Overall toggle count should be 5 as we are checking the toggle irrespective of Pre-REview/IRB Review.

Whereas for Toggle count based on Pre-Review/IRB-Review, the count will be 4 when filtered for "Pre-Review"

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Greg_Deckler 
    Thank you, I will test with the entire dataset and update.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    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?

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Greg_Deckler 

    Is there any way to make this dynamic based on the slicer selections. Since we have derived the index at the power query editor, the toggle values are fixed.