Database - MySQL (MariaDB) 10.x
I am trying to do a very simple bar guage (or even table is fine) visualization of a simple data structure. I have an Orders table and I would like to display the total number of orders for each user in the given time frame.
id | customer | created_on_formatted
1 | customer1 | 11-1-2022
2 | customer2 | 11-1-2022
3 | customer1 | 11-2-2022
4 | customer3 | 11-2-2022
I am expecting the Bar Guage to count the number of orders Per customer and display:
customer1 - 2
customer2 - 1
customer3 - 1
I’ve tried the following but am getting a SQL error:
SELECT customer as "metric", count(customer) as "value" FROM view_orders WHERE $__timeFilter(created_on_formatted)
Any help would be appreciated!