HI - I have data like this: I do not want to process for the Is_noshow = true.
I want a summary grid from the data as: I subtract the noshows from the totals.
Staff Name
Program Diaz, Alton Ray, Tor Tushar, Mict
Assertive Communication Training 2
Family Stabilization 1 1
----------------------------
Data:
full_name program Staff_name actual_date nd_date duration is_noshow
Cetro, Ausa Assertive Communication Training Diaz, Alton 12/01/2018 09:00am 12/01/2018 10:00am 1:00 FALSE
Coffee, Heather Assertive Communication Training Diaz, Alton 12/01/2018 09:00am 12/01/2018 09:00am 0:00 TRUE
Dodge, Feather Assertive Communication Training Diaz, Alton 12/01/2018 09:00am 12/01/2018 10:00am 1:00 FALSE
Jones, Seg Assertive Communication Training Diaz, Alton 12/01/2018 09:00am 12/01/2018 09:00am 0:00 TRUE
Acevedo, Cee Family Stabilization Ray, Tor 12/05/2018 12:00am 12/05/2018 2:00am 2:00 FALSE
Atlas, Kut Family Stabilization Diaz, Alton 12/06/2018 07:00pm 12/06/2018 08:00pm 1:00 TRUE
Alvarez, Branso Family Stabilization Tushar, Mict 12/03/2018 11:25am 12/03/2018 11:40am 0:15 FALSE
Alvarez, Branso Family Stabilization Tushar, Mict 12/03/2018 04:00pm 12/03/2018 05:00pm 1:00 TRUE
I want a summary grid from the data as: I subtract the noshows from the totals.
Staff Name
Program Diaz, Alton Ray, Tor Tushar, Mict
Assertive Communication Training 2
Family Stabilization 1 1
----------------------------
Data:
full_name program Staff_name actual_date nd_date duration is_noshow
Cetro, Ausa Assertive Communication Training Diaz, Alton 12/01/2018 09:00am 12/01/2018 10:00am 1:00 FALSE
Coffee, Heather Assertive Communication Training Diaz, Alton 12/01/2018 09:00am 12/01/2018 09:00am 0:00 TRUE
Dodge, Feather Assertive Communication Training Diaz, Alton 12/01/2018 09:00am 12/01/2018 10:00am 1:00 FALSE
Jones, Seg Assertive Communication Training Diaz, Alton 12/01/2018 09:00am 12/01/2018 09:00am 0:00 TRUE
Acevedo, Cee Family Stabilization Ray, Tor 12/05/2018 12:00am 12/05/2018 2:00am 2:00 FALSE
Atlas, Kut Family Stabilization Diaz, Alton 12/06/2018 07:00pm 12/06/2018 08:00pm 1:00 TRUE
Alvarez, Branso Family Stabilization Tushar, Mict 12/03/2018 11:25am 12/03/2018 11:40am 0:15 FALSE
Alvarez, Branso Family Stabilization Tushar, Mict 12/03/2018 04:00pm 12/03/2018 05:00pm 1:00 TRUE
Last edited: