Generating Rows for Employees with 0 Hours

Question

I need to calculate weekend hours for all employees however only a handful of employees will have hours logged on the weekend. The remaining employees will have their usual 5 days logged (or less depending on vacation/sick etc). I need to generate rows to bring in Saturday and Sunday dates for ALL employees on the list so we can count who has weekend hours and who has 0. I attached an example with the highlighted row is what I am trying to accomplish.

Rows.JPG

binu_acs · Answer

@jmathew94 I assume you want the weekends of the current month, the row generate tool generates all the weekends of the current month and appends to the original data

GenerateRow_021123.yxmd

apathetichell · Answer

brute force way.

summarize tool all dates in your range.

summarize tool all employees.

append. (making sure to accept over 16 entries.)

join your original data to your append by employee date.

rows where hours are null() did not exist in your oririnal datastream.

use a formula tool to identify them and make them as 0.

jmathew94 · Answer

@DataNath @binu_acs Any help you can provide? Thank you!