Formatting

• If your visu­al does not have com­mas for 4+ dig­it num­bers (Exam­ple, PCN Count)
  • Make a new mea­sure: PCN Count = COUNT(PCN)
  • Hav­ing your new mea­sure select­ed under Fields on the right, you can click the com­ma under the Mod­el­ing rib­bon > For­mat­ting

Show decimals/Changing the num­ber of dec­i­mals shown
Select the rel­e­vant mea­sure for this visu­al under Fields on the right. This exam­ple uses “Medi­an Time“
Two new cat­e­gories will appear on the rib­bon:

The num­ber of dec­i­mal places shown can be edit­ed under “Mea­sure tools” > “For­mat­ting”

Dec­i­mals are shown.

———————————————————————————————

For­mat­ting rows of a table so that it looks like colour head­ing dividers

• This is achieved by using the con­di­tion­al for­mat­ting tab under the for­mat­ting options of your table or matrix. For the sep­sis dash­board, this relied on hav­ing an index col­umn and was hard cod­ed. The rows that were to be coloured to act as head­ings word just reg­u­lar data rows with the head­ing name instead of data val­ues. These rows also had indexed val­ues, which enables cus­tom row colour­ing. It is not nec­es­sary to explic­it­ly have an index col­umn, as long as there is a col­umn that acts as a pri­ma­ry key for your table (all val­ues unique).