Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm building a Gantt Chart from a horizontal stacked bar instead of using an extension. I've done something similar in MS Excel and plan to use the same approach. The chart is set to show time worked based on timestamp data. Each row of data has a punch in and a punch out. Employees will often more than one punch instance daily (e.g. several punch in/out for breaks). Current chart set up as:
I repeat these steps as many times as necessary based on the number of punch instances by an employee in a day.
My Areas of Need:
In order to sort/order the punch instances in a day by an employee, I had to use the following Previous and Peek formula.
It seems to work in most cases, but when I load for my entire data table, some individuals do not work properly. I think errors occur when a row of punch data for an employee is not is chronological order by Start timestamp. (e.g. John Doe punch start in row 100 is less than John Doe punch start in row 80; therefore assigning a Punch_Count of '1' to both rows)
Attached is the QVW that I'm using.
Any Help is much appreciated.