I need to create a stacked bar chart using timestamp data. It is used to show time worked per day by employee. My data (Fact) table has the employee name, punch in (Start) and punch out (End). I need help creating a field that counts the number of times a person punched in on a given day. For example, an employee could have have 3 punch times in one day, that may not necessarily be in chronological order.
How can I assign that row of data a punch count as displayed below for John Doe? The criteria would be based on the Empl name and date.
