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?
I tried to use the logic from the pbix file you shared, but the field is not matching with the values as expected.
Please note , we need to derive two columns in PBI which is "Overall Toggle Count" and "Toggle Count based on Pre-Review and IRB Review".
These two columns which are available in the file is for refrence.
Thanks
Poojitha
Can someone please help on fixing this
- Greg_Deckler
Community Champion
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?
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"
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
Anonymous OK, so Overall Toggle count should be 4 then? Is that correct?