Hi, I’m currently counting the rows from all tables in my database and displaying it in a grafana table like this
TABLE_NAME AS 'Table Name',
TABLE_ROWS AS 'Total Rows'
(TABLE_SCHEMA = 'databaseName' )
GROUP BY TABLE_NAME;
Its working very well for a total running count, How can I add to the query so that it can filter based on timestamp?
Ive been pulling my hair out on this one