Skip to main content
This example uses a Markdown column to display a numeric rating as a row of stars in a table, with filled (orange) stars for the rating and empty (gray) stars filling the remainder up to five. A table column showing each row's rating as five stars, with filled orange stars for the rating and gray outlined stars for the remainder

​
Setup

This example uses a numeric rating field and two calculations: one for the filled stars and one for the empty stars. Both calculations use a SWITCH statement on the rating (column A). Add both calculations to your query, then set the column you want to display to Display as Markdown and hide the rating and remaining helper columns. The template references the calculations as {{calc_1.value}} (filled) and {{calc_2.value}} (empty). Calculation reference names depend on the order they’re created, so update them to match your own.

​
Example code

Markdown template:
CSS styles: