Forum Discussion

SharmaHimanshu's avatar
SharmaHimanshu
Qrew Trainee
5 years ago
Solved

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

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 = 1

In 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
------------------------------
Formulas and functions
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    5 years ago
    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's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------
    • SharmaHimanshu's avatar
      SharmaHimanshu
      Qrew Trainee
      5 years ago
      Hello,

      The fields are of type Numeric because they may have a higher value (like 2,3,4 or so on),  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....). 
      e.g:

      Pie chart will always have 2 slices only, Green represents Items cleared in 1st attempt & 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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        Try this

        IF(
        [Passed by Vendor]=1

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



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