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.
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.
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.
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