Pie Chart Total
I am creating a Pie Chart, I want to display the sum of all slices of the pie chart onto the chart or as a separate slice. ------------------------------ Del ------------------------------
Forum Discussion
Has this been answered somewhere?
------------------------------
Annetta Coleman
------------------------------
------------------------------
Annetta Coleman
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThere is no way to show the total number of records included in the pie chart. You are right they only show the number for each slice of the pie but not in total. You would have to have some kind of companion gauge chart or pie chart that gave the total.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark -
I don't understand, then the whole concept of creating a summary formula using distinct count in the pie chart if there is no way to actually use the summary formula on the pie chart. How / where would the pie chart summary formula be demonstrated? Separately, how would one create a companion gauge chart that associates to the data that has been included in dynamic filters?
Use Case:
- We have ~400 2021 projects in our project table.
- Each project identifies impacted value chain teams from a multi-select. (Each project will impact 1-n value chains)
- Each project identifies impacted markets from a multi-select. (Each project will impact 1-n markets)
- Each project identifies impacted systems. (Each project will impact 1-n systems)
- These 3 multi-select fields are dynamic filters.
- Each project goes through 5 project phases.
- Pie chart built to demonstrate Active Projects by Phase with dynamic filters to look at all, or various combinations from the dynamic filters.
- Pie chart dynamically changes based on the dynamic filters. Each slice identifies the # of projects in slice and allows drill down to the subset records below the slice.
- Easy to drop a picture of the pie if needed for an update presentation.
- Problem: It is untenable to do mentally or manually do the math of the sum of slices. There MUST be a way to do this. Thoughts????
------------------------------
Annetta Coleman
------------------------------- MarkShnier__YouI suggest that you try using a stacked bar chart. Instead of your slices being slices of a pie they will be slices of a vertical bar chart. The total height of all the slices will be easily readable off the Y axis.
I'm not sure if you have anything useful for the X axis. If not just make a dummy field which is the same for each record. Like "ALL".
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------Stacked Bar chart does not 'stack' by Phases because Phases is not an option in Y-axis. So basically becomes a bar chart for each phase (which by the way has the SAME problem as the Pie Chart in that it doesn't provide a total for all phases.
So frustrating to spend hours trying to format charts that can be accomplished in nano seconds in Excel. Obviously exporting to Excel is not an option because that looses ALL of the dashboarding and dynamic fields that are in QuickBase.
There simply MUST be a way to get a total of slices (in pie chart ) or a total of bars (in bar chart) or to be able to customize the fields available for Y-axis (in stacked bar chart) Thoughts?
------------------------------
Annetta Coleman
------------------------------
- We have ~400 2021 projects in our project table.
