I like to show results of some SQL queries in one dashboard. The SQL query fetches one row with one value (e.g. select count(*) from TABLE where-clause).
Can I push the result in the Text widget? If I add the SQL query to Text widget the Text widget remains empty, only a tooltip hover up "Last Value: <result> with DateTimeStamp".
I'd like to see it like this: "Number of dead sessions: <Result-of-SQL-query>".
Is this possible - maybe using of a variable/parameter?