Thanks again for the help, I’ve been trying to expand the system a bit before sharing it with the community. Any idea how i’d go about setting a different pay rate for each client? maybe an if statement?
this is the current global dataview block:
TABLE WITHOUT ID
Client,
Date,
Start,
End,
Hours,
round(Hours * 30, 2) AS Revenue
FROM ""
WHERE work
FLATTEN work AS W
FLATTEN split(W, " \| ")[0] AS Client
FLATTEN split(W, " \| ")[1] AS Date
FLATTEN split(W, " \| ")[2] AS Start
FLATTEN split(W, " \| ")[3] AS End
FLATTEN date(Date + "T" + End) AS Tend
FLATTEN date(Date + "T" + Start) AS Tstart
FLATTEN round((Tend - Tstart).hours, 2) AS Hours