Fix faulty query in dashboard panel #46
Description
The dashboard panel is currently displaying incorrect or incomplete data due to a faulty query. Please investigate the query logic and apply necessary fixes to ensure accurate information is retrieved and shown on the dashboard.
Expected Outcome:
- Dashboard panel shows correct, up-to-date data from the data source
- Query is optimized for performance
- Code changes are covered by appropriate tests
Additional Notes:
- Check for recent changes or refactors that might have affected the query logic.