Context:
Sometimes a single number is the most important thing you want to track in your dashboard or report, such as total sales…
By applying HTML format to the table chart, you can create a single number card as shown below:
Detail Solution:
- The workaround solution is basically to return a single value and use the html format option
- Using business calculation
concat
to combine two values from two columns. - Note that
concat
function currently only works with text fields, so you might need tocast
the number fields into text in the modeling layer:CAST(number as text)
- Here is an example of HTML format:
concat(
'<div style="display: flex; flex-direction: column; width: 300px; align-items:center; justify-content: center">',
'<div style="font-size: 36px; margin-bottom: 20px">',
{{ column1_value }},
'</div>',
'<div style="font-size: 18px; color: purple">',
{{ column2_value }},
'</div>',
'</div>'
)