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  = 1 2nd Slice sums rest of the records i.e which do not have all 3 field values = 1In Pie chart options I see, Series & 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.
 
------------------------------Sharma Himanshu------------------------------

MarkShnierYou · 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
------------------------------

MarkShnierYou · Answer

Np,

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 like

IF(
[Passed by Vendor]

and
[Passed by Retail]
and
[Passed by Customer], "All Passed", "Not All Passed")

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

Sign up

Login to the community