Better examples for metrics, multiple columns and group by


In docs/howtos there are too little examples of more or less complex graphs. Where can I get examples (for postgres + timescaledb, if it matters) of more complex selects with group by?

Not that I know right now. Anything specific you want to do?

I have a table - time (possibly sparse), channel (varchar), resolution(varchar), mobile agent (bool), connections (int).

I want to have (ideally) a single graph were I’ll be able to see stacked charts of two parameters with the third used as filter (channel, resolution - total, mobile only, desktop only; or channel, mobile, all resolutions or low and med and so on).

Data is stored in Postgres, I’m trying to understand how to use timescale on them.