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
MarkShnier__You
Qrew Legend
Qrew LegendCan 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
------------------------------
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
------------------------------
MarkShnier__YouQrew Legend
Qrew LegendWhen you put a stack bar chart on new dashboards they behave a bit differently than they do on regular reports or on regular home pages. The project counts for each of the stack bars would be embedded in the stack so they are easier to read. And when you hover over the stack it will give you counts of all your individual Phases. Granted it still does not do the total that you are looking for but the Y axis gives that total visually.
Anyways I just wanted to point out that if the Stacked Bar Chart chart starts to get close to what you need and you throw it on a new dashboard, it behaves a bit differently and perhaps better for your use case.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Anyways I just wanted to point out that if the Stacked Bar Chart chart starts to get close to what you need and you throw it on a new dashboard, it behaves a bit differently and perhaps better for your use case.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- MarkShnier__YouA suggestion for reducing the width of the Bar when there is only one bar is if it makes sense to use that X axis for something more useful than just ALL.
For example perhaps these projects are in different regions of the country or they are run by different teams or different project managers or maybe there are different T-shirt sizes of projects, like XL, L, M, and S.
i.e., If you have more than one stack then each stack would not be so wide.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ Yes, agree that having more stacks (by Value Chain or by Market or by T-shirt size of project) are various sets that would be improved by comparing projects within the set. The master version however that allows mixture of more than one dynamic variable is SUPER nice to have.
If you can figure out how to display the total on the pie chart, that would be strong preference for multiple dynamic filters. Rather odd to me that QuickBase does not provide this option from a standard pie chart. The variable is 'there' just cannot be displayed.
------------------------------
Annetta Coleman
------------------------------- MarkShnier__YouWell I definitely agree with you that on the pie chart in particular showing the total of all the pizza slices would be very useful.
There is a new system for suggestions / Request for Product Development. They have just migrated user voice over to a new platform which I have not yet tested. There is a tab for that at the left edge of the my apps page so if you put in that suggestion and there is a way to send a link to it I will give you some "Ranking" from me. Ranking is like getting more votes.
I know that some people here might think those just go into a black hole but in fact every single one is read by the relevant product manager for that aspect of the platform and is taken into account when they are assigning resources to development. Of course it's not their only source of Priorities but it's one of them, did you take some satisfaction of crossing ones off their list that have a lot of votes or in the new system a lot of ranking.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - I opened a feedback request. Thanks!
------------------------------
Annetta Coleman
------------------------------ - My problem was rather easily solved once I started using a Dashboard (rather than a Home Page).
Beside the pie chart I placed a Gauge report which serves to display the total count.
------------------------------
Annetta Coleman
------------------------------
