Rating Card

Options
Ashleigh
Ashleigh Coach
in Charting

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.

image.png

**If this answer solved your problem be sure to like it and accept it as a solution!

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited October 2023 Answer ✓
    Options

    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 :

    image.png

    Use the Heatmap table:

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MichelleH
    MichelleH Coach
    Options

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

  • ColemenWilson
    ColemenWilson Coach
    Options

    I agree with @MichelleH !

    If I solved your problem, please select "yes" above

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited October 2023 Answer ✓
    Options

    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 :

    image.png

    Use the Heatmap table:

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Ashleigh
    Ashleigh Coach
    Options

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

    image.png

    **If this answer solved your problem be sure to like it and accept it as a solution!

  • DavidChurchman
    DavidChurchman Coach
    Options

    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

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories