Reporting on workers’ timesheets

Sometimes data sets are missing entire records that are needed to tell a full story or allow us to make certain types of visualisation. This is where a technique called data scaffolding comes into play.

The provided text input gives you worker IDs, dates and the number of hours worked on those days.

Scaffold the data set and then use the reporting tools available in Alteryx, in order to mimic the desired output.

Download the Alteryx start file by Clicking Here