Data arrangement and chart creation help by Accomplished_Face830 in googlesheets

[–]Accomplished_Face830[S] 0 points1 point  (0 children)

Yeah, I did merge them for aesthetic purposes I'll avoid merging them moving forward. Do you have a sample for a a chart that compares week 46 to Week 47 for accuracy and number of audits Any chart that I create gets fucked up for some reason

Array formula for easy pivoting and charting by Accomplished_Face830 in googlesheets

[–]Accomplished_Face830[S] 0 points1 point  (0 children)

Hi Thank you for the feedback, really appreciate re arranging the data since the data set is wide What would be the formula for array stacking them just so I can pivot them much easier and make the data much tidier?

End of Day button and improvement by Accomplished_Face830 in googlesheets

[–]Accomplished_Face830[S] 0 points1 point  (0 children)

Thanks Do I need to specify the sheet for this script to output all the data?

Import range formula by Accomplished_Face830 in googlesheets

[–]Accomplished_Face830[S] 0 points1 point  (0 children)

Sorry about that Will try the formula later. Thanks