Discussions

Expand all | Collapse all

Pie Chart Report with similar field values

  • 1.  Pie Chart Report with similar field values

    Posted 01-05-2020 12:25
    Edited by Nicole Nicole 01-05-2020 12:29
    (example)

    So if this is my table (turned pie chart)
    Color # of shirts
    red 10
    pale red 3
    blue 5
    black 7

    But in the pie chart, I want Red and Pale red to both be grouped as "red" so the value would be 13 but in a table report, I still want to report them separately in a field. 

    Is there a way to do this?

    Thanks!



    ------------------------------
    Nicole
    ------------------------------


  • 2.  RE: Pie Chart Report with similar field values

    Posted 01-05-2020 12:39
    No Problem,
    Just make a new formula text field called [Pie Chart Color]

    Case([Color],
    "pale red", "red",
    [Color])

    but on a more general situation when you have more values it would look like this


    Case([Color],
    "pale red", "red",
    "pink","red",
    "lime", "green",
    "emerald", "green"
    [Color])

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