Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
4 months ago

Pie Chart Help

I feel like I am missing something obvious.

I have a table of Properties. One field (numeric dropdown) states how many Drinking Wells they have on the property. One field states how many Irrigation wells they have on the property.

I want a pie chart that compares the number of total drinking wells vs non drinking (irrigation wells).

If I had a wells table, and each well was labeled Drinking or irrigation this would be easy. But somehow I am just not seeing how to do this in my current format. A single record may contain a number of drinking wells AND a number of irrigation wells, and I can't figure out how that record is represented on both chunks of the pie chart.



------------------------------
Mike Tamoush
------------------------------

2 Replies

Sort By
  • BlakeHarrison1's avatar
    BlakeHarrison1
    Qrew Trainee
    4 months ago

    Unfortunately, I believe you've already stated the answer. In that particular structure, you can't. A pie chart reports on a single numeric value, aggregated based on a single text value.



    ------------------------------
    Blake Harrison
    Systems Analyst / Quickbase Developer
    BCF Partners Capital
    Houston TX
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 months ago

    I think you can do this with a summary report, because you can Summary Variables and Summary Formulas.  But it's numbers and not graphical.  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------