(This section of the documentation only describes the object Text from SQL query, not how to add those to a specific dashboard. If that's what you're looking for, have a look at this section instead. )
The purpose of this object is to present semi dynamic information in a form that mixes fixed text with dynamic updates of values. This can be achieved by constructing a SQL query that combines a static text with the dynamic fetching of data from one or more tables. And then converting the result to a single string. Once the SQL is verified to be working then the query should be referenced when creating a Dashboard object in order to use it when defining "Text from SQL" objects. When that is done the result might look something like the image below, you also see the settings windows as well. You can read more about how to set up SQL queries here .
Just
as with any other Dashboard object, the layout must be saved along with the
overall Dashboard, for all setting's to be finalized.