Rating Card

Ashleigh

Anyone have any idea or work around to show ratings besides just table or bar chart? I have a survey where people rated items 1-5 stars. I would like to show that in a format like this based on responses.

MarkSnodgrass

You can make stars by doing a beast mode like this:

(CASE

WHEN AVG(Object_Health_Score) >= '.8' THEN ' ★★★★★'

WHEN AVG(Object_Health_Score) >='.6' THEN ' ★★★★☆'

WHEN AVG(Object_Health_Score) >= '.4' THEN ' ★★★☆☆'

WHEN AVG(Object_Health_Score) >= '.2' THEN ' ★★☆☆☆'

WHEN AVG(Object_Health_Score) < '.2' THEN ' ★☆☆☆☆'

END)

They end up looking this :

Use the Heatmap table:

MichelleH

@Ashleigh What if you tried a Waffle Gauge and set your symbol as a star with a target value of 5?

ColemenWilson

I agree with @MichelleH !

MarkSnodgrass

You can make stars by doing a beast mode like this:

(CASE

WHEN AVG(Object_Health_Score) >= '.8' THEN ' ★★★★★'

WHEN AVG(Object_Health_Score) >='.6' THEN ' ★★★★☆'

WHEN AVG(Object_Health_Score) >= '.4' THEN ' ★★★☆☆'

WHEN AVG(Object_Health_Score) >= '.2' THEN ' ★★☆☆☆'

WHEN AVG(Object_Health_Score) < '.2' THEN ' ★☆☆☆☆'

END)

They end up looking this :

Use the Heatmap table:

Ashleigh

I did try a waffle but could not figure out how to get it to reduce the waffle size to one row.

DavidChurchman

To generalize @MarkSnodgrass 's solution a bit, you can use most Unicode characters to hack different visuals like this into your tables, summary numbers, chart labels. There a lot of lists of available Unicode characters, but this is my go-to: https://www.vertex42.com/ExcelTips/unicode-symbols.html

roxanaboboescu

All the comments are super helpful, I'm working on a similar thing and need a star rating to show up. thanks all!