Chart examples / templates with charts?

1

Do you have any docs or templates that features use cases of chart formulas?

I’m a bit stuck with how to use the chart formulas properly and I couldn’t find any templates in the collection that had charts. I tried to search for “chart” and that’s all I found: https://coda.io/templates?search=chart

Thanks a lot,
Zsolt

2

Hey @Zsolt_Bako,

yeah they can be tricky. I made some examples here.

Do you struggle with something in particular?

1 Like
3

@Daniel_Stieber super nice example!

If you don’t mind, maybe it could be added to the general coda library?

1 Like
4

Thank you very much @Daniel_Stieber!

That is super helpful. This should definitely be available somewhere in the documentation.

1 Like
5

Thanks!

Oh yeah of course. I will wait for the new charts that were anncounced before submitting it to the library.

6

Hi @Daniel_Stieber :wave: perhaps you can help :sweat_smile:
I am trying to do a chart w/ 2 columns

  1. region
  2. sector(s)
    And there is the issue, I can’t add the sectors to region, see below

Bildschirmfoto 2020-06-04 um 19.02.41
Bildschirmfoto 2020-06-04 um 19.02.411410×798 59.5 KB

I think because all sectors to a region are in the same (and one) column.
Any thoughts how to solve it?

Bildschirmfoto 2020-06-04 um 19.04.04
Bildschirmfoto 2020-06-04 um 19.04.041278×984 82.3 KB

Best
Thomas

1 Like
7

Hey Thomas,
in general, I think you are right, it is not working because the chart can’t split the values of the multi-select.

I’m afraid most charts don’t work/make much sense without numeric data to show. So I’m not sure what your result should look like. Can you maybe make an example drawing of what you want to achieve? :slight_smile:

If you want something like here, you would have to make a row for every entry with the city name and only one category (so you end up with like 10 rows with city Basel).

Bildschirmfoto 2020-06-04 um 19.37.49
Bildschirmfoto 2020-06-04 um 19.37.49818×453 13.7 KB

Maybe there is a way to split this up automatically or with a button.Hm actually I’m pretty sure it is possible somehow, but haven’t found an example on first check.

8

Thanks @Daniel_Stieber, that’s why I open this ticket as well :arrow_right: FormulaMap for creating multiple rows :wave:

9

EDIT: Updated the broken link here, because I still get notifications of people clicking on it, but the link did not work for a while alredy. Be aware that these examples use the chart formulas and the doc is 3,5 years old. Coda changed a lot in that time. (Still working though.)