[visualization-api] Re: Google Sheet Query Language

2024-04-11 Thread 'Ray Thomas' via Google Visualization API
Hi Ale, I have no use-case for using CSVs at all. What happened was that years ago I was working for a university looking after their website. They wanted graphing capabilities for their sites but between them, Web Services and IT wouldn't provide the means of connecting to any of our

[visualization-api] Re: Google Sheet Query Language

2024-04-11 Thread Ale
Excuse me Ray, did you have a similar goal? Could you please share your use case? Maybe it could help me finding another idea/path. I sent a CSV file to facilitate the forum to have an input table to work with. In my case I have a table in a sheet, daily filled in with new rows, each time I

[visualization-api] Re: Google Sheet Query Language

2024-04-10 Thread 'Ray Thomas' via Google Visualization API
I couldn't get your CSV file to work at all wthout making some changes to it, changing the commas to decimal points and the semicolons to commas. Even then, I couldn't get a query to work with it. I know the query works, because I used it in a Google Sheet