Pie Chart Report with similar field values
(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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNo 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
------------------------------
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
------------------------------