There are 5 different representation types.
With just one click you can turn the measure into: Text, Indicators, Progress bar, MiniChart or BulletChart.
Text Representation
The Measure can be defined as text.
Text can also have the HTML or URL format by setting an URL Label.
Indicators
Indicators can be set for the measure.
Different color can be defined for values above, below or equal to zero.
Progress bar
Progress bar is a bar representation of the measure, you can set the color either using the color picker or by expression.
You can also toggle show value to show the figure inside the bar.
Bulletchart
Instead of looking at the text you can look at it as a bullet chart.
With just 1 click immediately transform your column into a bulletchart.
Set the target, define the target width and color for target and objects underneath and above it .
You can also toggle show value to show the figure inside the bar.
Minichart
The MiniChart allows you to add representations into each row of the table based on the dimensions, choosing from these options.
- Small line chart
- Bar chart
- Composite chart
- Pie chart
- Box plot
This works by displaying the measure across the provided dimension for the mini chart. Please note that the dimension must be a single field and cannot be a calculated dimension.
The minichart now support set analysis (from v3.6.2), however, only a single use of set analysis will work. The requirement here is that there is only one occurrence of "{<" and ">}" respectively. This means that the following is not supported:
- Specifying more than one field in a single set
- Using 2 sets within a single expression ( e.g. 2 measures, each with set analysis is not supported)
Why not get creative and try creating your own kind of minichart using symbols and emojis?
repeat('❤ ', rangemax(ceil(max(rand()*10)),1))
Images
Selecting Text as HTML for a column means you can also start to use images within your table.
If you insert the HTML code string you want to use into Expression the image (or images) should display in the column.
We've included an example below, with the output in the table and an example code structure, with the condition that the image changes if the City field has the value Seattle.
