Forum Discussion
Count of Status
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?
Community ChampionAnonymous 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?
We are deriving two columns,
1. "Overall Toggle count" should be irrespective of "Pre-Review" and "IRB Review".
2. "Toggle count based on Pre-Review/IRB Review" should be for "Pre-Review" and "IRB Review" Separately.
Greg_Deckler
Thank you, I will test with the entire dataset and update.- Greg_Deckler
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
Anonymous OK, so Overall Toggle count should be 4 then? Is that correct?
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"
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.