Can you try this and tell me the results.
1. Create a formula text field called [ALL]. The formula will be "ALL".
2. Make a stacked Bar Chart with ...
- X axis is [ALL]
- Y axis is # of Projects
- Series is Phase.
As for your question 1, I don't see how that would help you to have the slices of the pie be count distinct values. That won't help and you would lose the count of # of Projects. I understand it, you want to be able to Visualize the number of Projects by Phase and how are your users to use the dynamic filters to adjust which projects are included.
For the companion gauge chart comment that I made well that would give you a total there is not a way to have the dynamic filters on one report magically automatically adjust the dynamic filters on another report. When I answered that question I did not realize that your users wanted to adjust the dynamic filters, I thought it was just a static pie chart say on the dashboard.
Give that Stacked Bar chart one more chance and let's see where we end up. :)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 11-05-2021 07:50
From: Annetta Coleman
Subject: Pie Chart Total
Hi Mark -
In order for a stacked bar to 'stack' by phase if for Phase to be in the Y-axis. Setting the series to Phase has same result as previously reported in anchoring the Phase to the X-axis which creates a standard bar chart with the same problem as the pie chart is that the total (number of projects of all phases) is not represented anywhere on the chart.
I remain curious related to:
- What one would do with the report summary formula built in the report that counts distinct values? I have created this but cannot figure out how to place the total anywhere on the chart.
- How to create and trigger a 'companion gauge chart' you mentioned earlier in this thread?
- Maybe I didn't have enough coffee last night (or this AM), but it seems like I am missing a key fundamental aspect of pie (or stacked bar) charts to make them act like a standard industry pie or stacked bar chart that includes a simple total of the values in all slices of pie or all bars on chart.
------------------------------
Annetta Coleman
Original Message:
Sent: 11-05-2021 06:27
From: Mark Shnier (YQC)
Subject: Pie Chart Total
Please try the Stacked Bar again and set the Series to be Phases. The Y axis will just be # of Projects. The height of the Bar will be the total, alight you will need to estimate how high it looks against the Y
An alternative would be to use the same report but obviously that's not very visual.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 11-05-2021 00:12
From: Annetta Coleman
Subject: Pie Chart Total
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
Original Message:
Sent: 11-04-2021 23:32
From: Mark Shnier (YQC)
Subject: Pie Chart Total
I 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
Original Message:
Sent: 11-04-2021 22:43
From: Annetta Coleman
Subject: Pie Chart Total
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
Original Message:
Sent: 11-04-2021 18:33
From: Mark Shnier (YQC)
Subject: Pie Chart Total
There 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
Original Message:
Sent: 11-04-2021 16:44
From: Annetta Coleman
Subject: Pie Chart Total
Has this been answered somewhere?
------------------------------
Annetta Coleman
Original Message:
Sent: 05-26-2021 10:57
From: Phelan Sanders
Subject: 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
------------------------------