cancel
Showing results for 
Search instead for 
Did you mean: 

Reports - Raw Data

gersonc96
Explorer
Explorer

I would like to know if it is possible to get raw data more comprehensive and easy to present. What I mean with this is that instead of putting for example the sign-in-out per people in rows, could that be on columns, so it could be easy to manage in Excel? The same thing applies to the people assigned to a queue, where they change to multiple auxiliaries, (bath, meal, downtime Manager Approved, etc.) starting time can be in one column, and the end time in another column, just instead of everything in rows,

Thank you in advance for your assistance.

3 REPLIES 3

IISA
Explorer
Explorer

Hi user, did you get a response on this question. All my data is in one row, can it be distributed in different columns? To be easily filtered? 

Hi, no I did not receive any answer from Zoom. They suggested to submit a feature change, but it has not changed anything. What we did with the team is to paste the raw data in the Column A, and in Colum B we use this formula for Sign In. =INDEX($A$1:A100, (ROW(B1)-1)*2 + COLUMN(B1)-1), and for Sign Out. =INDEX($A$1:A100, (ROW(C1)-1)*2 + COLUMN(C1)-1), I hope this help you

gersonc96
Explorer
Explorer

Hi, no I did not receive any answer from Zoom. They suggested to submit a feature change, but it has not changed anything. What we did with the team is to paste the raw data in the Column A, and in Colum B we use this formula for Sign In. =INDEX($A$1:A100, (ROW(B1)-1)*2 + COLUMN(B1)-1), and for Sign Out. =INDEX($A$1:A100, (ROW(C1)-1)*2 + COLUMN(C1)-1), I hope this help you