AnsweredAssumed Answered

Pie Charts

Question asked by cgallardo on Mar 14, 2013
Latest reply on Mar 17, 2013 by cgallardo

Hi,

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.

 

positions.JPG

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.

 

rships.JPGchart.JPG

Outcomes