Hi, do you know that you can develop a dashboard using Google Sheet? It is simple, and zero code required!
Discussion on implementation of Dashboard on Google Sheets
My dashboard, made another table for the query.
The link to my file, https://docs.google.com/spreadsheets/d/1SlkZJayhvtkQ7G2DLntP_h84na9BwfEOzLHMra6lOvk/edit#gid=233774907