Can anyone help me with the correct expression? I’m looking to create a Pie Chart that shows me the Team Workload % against the Teams Total Capacity.
I have a Project Leads Table. Each Project Lead has a Workload Value (which is calculation based on the number of projects assigned to them) and a Capacity Value.
In the same Project Leads Table, I have created a virtual column called [Team Workload] which sums all the Project Leads Workload. In addition, I have a virtual column called [Team Capacity] which sums all the Project Leads Capacity.
It’s easy enough to create new virtual columns above to then get the Team Workload vs Team Capacity Percentage.
What I don’t understand is how get this value to show up correctly on a Pie Chart.
Appsheet wants to show me the Project Leads Workload Breakdown which is not what I want.
Since these are VCs, are those showing identical sum values in each of the rows of the table?
If so, I think there is no good way to show it natively in the Pie chart. Pie chart sums up totals well in a single column against the label column of the table, something like below sample app shows
I don’t think this helps me. The column I’m summing is Project Workload for each Project Lead. This virtual column would be called Team Workload. I would like to see Team Workload in a Pie Chart against the Team Capacity. Example 75% Team Workload with 30% capacity remaining.
In the example you shared, it shows [Order Status] can be either Completed or Open and the graph shows the percent between the Two using an aggregate Pie Chart.
My example seems a bit complicated as it includes numbers calculated in Project Workload and Capacity by Project Lead.