Pie Chart: Consolidate more than 1 field as a slice.

Question

Hello,Is it possible to consolidate more than 1 column to show as a 1 slice on a pie chart?Requirement:3 different Fields in QB tables are:
Passed by Vendor
Passed by Retail
Passed by Customer
Pie chart with 2 slices is needed in following way:1st Slice sums records with all 3 field values&nbsp; = 1&nbsp;2nd Slice sums rest of the records i.e which do not have all 3 field values = 1In Pie chart options I see, Series &amp; Data Values but can not figure out how to aggregate 3 fields in there.Could it be possible to use a Formula field/Report Formula field in here?Please suggest.Thanks in advance.
&nbsp;
------------------------------Sharma Himanshu------------------------------

markshnier__you · Accepted Answer

First create a new formula text field called [Passed first try] using the formula above.

You will select [Passed first try] the "Series"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

markshnier__you · Answer

Try thisIF([Passed by Vendor]=1
and[Passed by Retail]=1and[Passed by Customer]=1, "All Passed", &nbsp; "Not All Passed")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

Np,&nbsp;you can make a formula field to calculate to say "All Passed" or "Not All Passed"I'm not sure what field type those fields are, but if they were checkboxes, the formula would be likeIF([Passed by Vendor]
and[Passed by Retail]and[Passed by Customer], "All Passed", &nbsp; "Not All Passed")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

sharmahimanshu · Answer

Hello,The fields are of type Numeric&nbsp;because they may have a higher value (like 2,3,4 or so on),&nbsp; Value 1 would mean that the thing was passed in 1 go.Chart is needed(preferably Pie chart) to be plotted of the items that were passed in 1 go against the items that required more attempts(i.e 2,3,4....).&nbsp;

e.g:Pie chart will always have 2 slices only, Green represents Items cleared in 1st attempt &amp; Yellow represents all the others.

Please suggest how to plot the chart like this or let me know a better way of a representation.Thanks for help.------------------------------Sharma Himanshu------------------------------

sharmahimanshu · Answer

The options I see in the Pie chart settings is Size &amp; Data Values
Size just lets me choose one column, I do not know how to use this interface to form the pie chart using that formula? Could you please help little further.Thank you.------------------------------Sharma Himanshu------------------------------

sharmahimanshu · Answer

Thanks for the help Mark .------------------------------Sharma Himanshu------------------------------

Forum Discussion

Pie Chart: Consolidate more than 1 field as a slice.

6 Replies

Related Content

Pie Chart Help

Stacked Bar Chart

Charting Help

Gantt Chart Reordering

Chart Help

Recent Discussions

Current URL Display without JavaScript

Remove the save button when from new forms format when applying I-forms (IFV=1) #354382

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting

APP - Communications

Kanban WIP Limits