I have a SQL query that returns the number of connections to a device per day. I want to visualize the development of most used devices per day with a stacked bar chart. For overview purposes, I only want to show the top 10 devices with respect to the currently selected time span. More specifically: When I change the time span, I want the chart to update itself with the appropriate devices that were used the most in this time span.
I probably need to query all records inside the table and make some adjustments inside Grafana but I cannot find the right configuration.
Thanks in advance!