Business Vs. Non-Business Hours

Data Pipeline

It is possible in Chartio to adjust the dates of reporting, such as differentiating between weekends from the typical Monday-Friday business hours. In this example, we want to add some overtime pay onto employee wages for weekends they worked.

  1. Drag Shift into the Dimensions field twice and select different Time Buckets: one for the Day (or Date) of Shift and the other for Day of Week.

    Set up your chart by dragging shift into the Dimensions field twice

  2. In the Pipeline, add a Combine Columns step to combine the hourly wages and hours worked per day columns. Select the option to hide the original columns so that the calculation will happen behind the scenes.

    Add Combine Columns step in the Pipeline

  3. Use a case statement to edit the Gross Pay per Day column to add time-and-a-half to weekend days:

    CASE WHEN “Day of Week: Shift” LIKE ‘S%’ THEN 1.5*(“Gross Pay per Day”) ELSE “Gross Pay per Day” END

    Edit Column using a case statement

Related Data Pipeline Help Articles

See more