Work with Multiple Series in Pocket Query with Google Charts

[Joao Flavio Mendonca]

Hello, 

I need to create a template in Pocket Query using the line chart from Google charts with multiple series (in fact 34 series).

So, I have a query that results a table with 3 columns and I want to have one column as x axis the other as y axis and the other as the name of each serie.

Do you know how can I perform it?

Thanks a lot

Joao Flavio

[Felix Grund (Scandio)]

Hi @Joao Flavio Mendonca,

Thanks for reaching out and sorry for the late response (we just realized some messages here failed with our filters).

What you want to achieve is certainly possible because the JS code in PocketQuery is merely a wrapper over the Google Chart library. I think your key is to create the data table array for the chart manually. We have tried to explain this in one specific section "Overriding the Data Table for Google Charts" of our documentation here. The general docs of the `PocketQuery.chart()` might help too.

In short, you'll have to pass a `dataTable` array to your `PocketQuery.chart` call in order to override the default result that is otherwise use in the method. This should be the same as in the documentation of Google Line Chart.

Maybe this is already sufficient as a primer, but please do follow up here if you need more help!

Best, Felix