I am trying to show an improvement in lapsed times for patient assessments
and want to pivot the data. I know its possible because I have a similar
chart in front of me but when i drag the lapse time field into the table (The
x axis is days of week and the y axis is shifts (day night evening) I only
get the count of the times and not the data. I have tried formatting as hh:mm
but that changes the data to 00:00. Can anyone assist