GitHub user dosubot[bot] added a comment to the discussion: Login redirection does not use subpath prefix
<!-- Answer --> The best option for dynamic text driven by SQL queries is the **Handlebars chart type**. It lets you write HTML/text templates that render data from your SQL query using Handlebars syntax [[1]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/plugins/plugin-chart-handlebars/README.md#L25). **How to use it:** 1. Create a new chart and select **"Handlebars"** as the visualization type 2. Configure your dataset/SQL query as usual 3. In the chart configuration, write your template in the Handlebars editor. You can reference query columns directly: ```handlebars <h2>Total Revenue: {{formatNumber revenue}}</h2> <p>Last updated: {{dateFormat updated_at format="MMMM DD, YYYY"}}</p> <p>Status: {{status}}</p> ``` **Built-in helpers** [[2]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/plugins/plugin-chart-handlebars/README.md#L77-L99): - `{{dateFormat column format="YYYY-MM-DD"}}` — format dates - `{{formatNumber column}}` — locale-aware number formatting - `{{stringify column}}` — convert objects to JSON - You can also add custom CSS via the style template control **Other options depending on your use case:** - **Big Number chart** — if you just need to display a single metric value prominently (e.g., a KPI) [[3]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/plugins/plugin-chart-echarts/src/BigNumber/BigNumberTotal/index.ts#L30-L38) - **Table chart** — if you want to show multiple text rows/columns from a query Note: The **Markdown** dashboard component is static only and cannot reference query results [[4]](https://github.com/apache/superset/discussions/41422) — use Handlebars instead for dynamic content. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).* --- Share context across your team and agents. Try [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-tagline&utm_term=apache%2Fsuperset). [](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-feedback&utm_term=apache%2Fsuperset&message_id=2023bc60-87ae-46b6-9cbe-48a82192f09c) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-learn-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-add-team&utm_term=apache%2Fsuperset) GitHub link: https://github.com/apache/superset/discussions/40082#discussioncomment-17439230 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
