Need some help creating a pie chart

1

Dear Coda experts,
I’m trying to create a pie chart and finding it to be a lot more challenging than it seems like it should be…
Can anyone help? (The specific problem is laid out in the call-out box in the document)

2

Hi @Keap_Ops,

I added a formula to “Column 2” of the “Staffing Totals”-Table.
Please check if that is what you visualized.

Jannis

1 Like
3

@Jannis - that’s exactly what I’m looking for, thank you!
I’m not familiar with that SwitchIf formula - looks like a good one to know - thank you again!

1 Like
4

Hi @Keap_Ops,

You’re welcome!

The SwitchIf() formula is indeed a good formula and definitely one of my most used, BUT I recommend you always look for patterns in your data that you can build your formulas on. I see the SwitchIf() formula as the very last and manual way to get things working. If your data contains other patterns to base your formulas on, I always recommend you use those instead of writing a SwitchIf() formula with lots of conditions.

In your case, I couldn’t find any patterns. That’s why the SwitchIf() formula was the only way that came to my mind.

Jannis

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.