Formula error
I am having trouble creating a field that can be added to the series section of a pie chart. The pie chart needs to show how a color associated with each condition to be able to split the pie chart i...
Forum Discussion
Hey Tonya, like Mark mentioned we can't always control the colors that will be used, but you can control the results of your formula to force otherwise unrelated values into common groups. The groups may then be included as the Series in Pie Charts.
I don't think your formula logic as it stands will yield the expected result as there are multiple conditions that are unclear. For example, if we take the just the first condition, what are you hoping to evaluate and what should be the outcome if true? To me it seems like you blended the logic of a couple different scenarios and they may be better are two different formulas, for example one formula outputting the "age" and other "outputting" the type?
Then, you would take the results of that formula and set it as your Series. Quickbase will then auto-color each Series group (pie slice). If you go back into the report settings, you can manually override the colors by clicking the little color swatches in the Legend.
Oh, regarding your error … it's because there is a mismatch between what you have set as your Field Type (Boolean) and the results of your formula which is presumably outputting text (e.g. "HIPO" or "#2ca01c").
Hopefully that helps!
------------------------------
Brian Seymour
------------------------------
Thank you to everyone! I was able to fix the error. I did not need the 1 or the 0 at the end and I also had to separate each field and put the result next to each condition.
------------------------------
Tonya Jacques
------------------------------