I’m new to grist and this seems trivial but I can’t seem to figure it out. I have the following data
- Employee Name
- Total Hours Worked
- Hours worked in category 1
- Hours worked in category 2
- Hours worked in category 3
What I want is a pie chart with percentages of hours worked across all employees by category
What I did was put these all into columns, I then created a summary table for the totals of each category’s hours.
So now I have a summary table with the sum of total hours worked across all employees separated by category. All I want to do is take these 3 sums and stick them into a pie chart to get percentages, however it seems like pie charts don’t work this way. The data needs to be vertical not horizontal.
I tried to reference the summary data, and put it into a new table but I can’t do that either
Thanks for any help
As you define three different columns, I guess you have a defined number of categories (otherwise it would be far better to have a
Name, Category, Hours scheme for your
Example table). Then you can afford a
Categories table with
Category, Total hours columns. The
Total hours column would be a formula column with this formula:
if $Category == 1:
elif $Category == 2:
elif $Category == 3:
Hi jperon! I am experiencing problems to open the posted sample due to access issues. Could you please take a look into it? The sample would be really, really helpful for me! Thank you!
Sorry, I just opened public access (I thought it was done before). I took the occasion to add another page that organizes data differently, but IMHO in a better (more normalized) way.
Hey wow that was quick! Thank you very much for helping out!