Adding a Line Break in the KPI Widget

This tip is how you can concatenate dynamic data for display in your KPIs and include a line break for separation. Using a line break to combine data can help make things easier to understand both in data grids and KPIs.

The formula used in the video:

PostgreSQL:

concat("sales_pipeline"."product", '</br>',to_char(sum(?),'l99,999,999,999D99'))

a similar version for MS SQL:

concat([sales_pipeline].[product], '</br>',FORMAT(sum(?), 'C'))