I don’t know how to build a dataset that Glide Chart likes. I have the data available via a query but can’t figure out what Glide charts wants within a table to build a clustered chart like the below (built in Google sheets). I am trying to compare multiple rows clustered by quarter in a time series. I could use this same technique for sales reps, business development, etc. (BTW Google sheets was painful cause it wanted data as columns not as rows…ugh)
But….I can’t figure out how to aggregate/format the data (as rows) for Glide’s component. If I need a third-party service, what do people recommend?
Thx
