Calculated Field / Column Question

Could you Group the report by Project, collapse the grouping, and then summarise each "count" column by sum? 

This would display the sum of each column at the top of the group.

TIP: if this solves your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

Focusing on your charts question: I don't think you will be able to get all 6 counts into one pie or bar chart. The closest you'll get within workfront is 6 charts on one dashboard (one for each type of menu item). Hopefully it makes sense if I give you the analogy of making a pie chart out of project statuses. A project only has one status field, so when you make a pie chart, you're reporting a bunch of different statuses in your pie, but it is coming from one field. This thing you are trying to do is coming from 6 fields. There's no way to combine it into one field because you have 6 answers. Normally I would be trying to locate an answer using a matrix report, but if you want a visual chart I think this is just out of the question.

If you make them horizontal bars, this will probably produce the best result. 

Yes! You can create a calculated column that sums up the total occurrences of each value across all projects. Here's how you can approach it:

Solution: Adding a Total Count Column

You need to sum up each Value Count column across all rows to get a total count of each unique value.

Steps to Achieve This in a Report:

1. Create a Summary Report:

   • Group the report by none (so you get a total count across all projects).
   • Use aggregations (SUM function) for each Value Count column.

2. Use a Calculated Column (if available in your system):

   • If your reporting tool supports formulas, create a calculated column like:
     mathematica

     CopyEdit

     Total A1 Count = SUM(A1 Value Count) Total A2 Count = SUM(A2 Value Count) Total B1 Count = SUM(B1 Value Count) Total B2 Count = SUM(B2 Value Count) Total C1 Count = SUM(C1 Value Count)
   • This will aggregate all occurrences of each value across projects.

3. Generate a Pie Chart:

   • Once you have the total counts, plot them in a pie chart.
   • Each slice of the pie will represent how many times each value appears across all projects.

Expected Totals for Your Example Data:

Value Total Count

If you’re using Text Mode Reporting, you may need to manually specify the column aggregation as a SUM function.

Would you like help writing a specific formula based on the platform you’re using (e.g., Workfront, Excel, Power BI)?