Is it possible to display a pie chart based on a single row in a table? Either directly or via some type of magic?
I’ve got a table which I’m logging some numerical data on a weekly basis. In addition to displaying this using a line chart, I also want to display a pie chart using the data from a single row (i.e. the most recent one).
which I’ve tried directly in my browser, resulting in an Error 502. I’m not sure if this is because there’s an error in the URL, or if Google is having some issues.
I wonder if there’s another way to do this? Coda pie charts are expecting the sections of the chart to be different rows. Is there a dynamic way we can create a table populated from another table as multiple rows instead of columns?
If you’re willing to adjust the format of the Services Data table, You could structure it with Date as the first Column, Type (or whatever) as the second, and Count as the third; Type is a select-list of your four existing columns, and count is the associated number for each type.
For your charts then, you can use date as the horizontal axis and the values are the numbers in Count, then in the Chart Options, segment the data by Type to get your pies and lines. This will also let you add filters to isolate some types from the others if you want to later.
That should work as-is for an additive chart - if you only want the last two weeks, you can do a filter on the charts to only show that amount of time and you should be off to the races.