I’m rather new to grafana and I’m using it to get an overview of what brands our customers order among our items.
I’m trying to make graphs with an aggregation of the brands ordered we recieve per week in our order database. Our database is postgres and has the following relevant tables:
(and a lot more fields)
how do I create the approprialte sql aggregrations? I can get the total number in the table