I’m having a very basic issue, at least it feels like one. It’s something I can easily achieve in Google Sheets, but I just cannot make it work in Coda. I would like to use Coda for this one because it the entire presentation more interactive.
Anyhow, my issue is that I just can’t make a basic line chart. My data is formatted as follows:
The goal is to present the data in a line chart that visualises year on year growth. But I feel stuck. I reckon that it has something to do with how Coda charts are able to present vertical and horizontal data? Can those be switched?
I wrote this contribution that includes a transpose logic. You apply a listcombine() to all alike data parts.
When you have a bit more complex set up, you should work a bit differently.
when all data sets are of equal size, you can have a logic like this. As you see below the columns with the listcombine() function go by the prefix hlpr
