I am trying to generate a pie chart of activities performed on any given day by different positions/role (i.e engineer, senior engineer, junior engineer, etc)
The working day is divided into equal intervals of 30 minutes and is presented in a prefilled portal (via a script).
The position description is picked from a drop down box.
Is the table design below the appropriate one or should I be using self joins? I did try self join but I could not get it to work either. As you can see the chart I am getting is displaying each entry as an individual entry instead of grouping together engineers, cleaners, etc.