×

Data

# Create Custom Star Ratings in Tableau

//

When it comes to ratings in Tableau, you should be able to customize them as much as the platform allows you to customize its other aspects. This process will show how you can tailor your ratings to include half, or even quarter, stars and change the rating shape entirely!

Step 1: Download the CSV file (found at the bottom of this post), and add it as a new data source in Tableau.

Step 2: Create a new sheet, click on Analysis, put X on Columns and Y on Rows:

Step 3: Download the star tiles attached at the bottom of this post (or use your own – could be wine glasses, plates, phones, whatever you like), and paste them into the folder MyTableauRepository (inside your Documents folder).

Step 4: Paste the following calculation into a new calculated field:

```CASE ATTR([X])
WHEN 1 THEN IF ATTR([PasteField]) < 0.5
THEN 'empty'
ELSEIF ATTR([PasteField]) < 1
THEN 'half'
ELSE 'full'
END
WHEN 2 THEN IF ATTR([PasteField]) < 1.5
THEN 'empty'
ELSEIF ATTR([PasteField]) < 2
THEN 'half'
ELSE 'full'
END
WHEN 3 THEN IF ATTR([PasteField]) < 2.5
THEN 'empty'
ELSEIF ATTR([PasteField]) < 3
THEN 'half'
ELSE 'full'
END
WHEN 4 THEN IF ATTR([PasteField])  < 3.5
THEN 'empty'
ELSEIF ATTR([PasteField]) < 4
THEN 'half'
ELSE 'full'
END
WHEN 5 THEN IF ATTR([PasteField]) < 4.5
THEN 'empty'
ELSEIF ATTR([PasteField]) < 5
THEN 'half'
ELSE 'full'
END
END
```

Step 5: Place the calculated field on form, filter for a rating, and adjust the form for each value: empty, half and full. You might want to increase the size of your forms, remove any grid lines or zero lines, and hide row and column headers now.

Tip: If you are struggling with the blend, you can download the Tableau workbook, in which I have included a version that does not use a blend but is slightly more complex to build.

Now, go get your five-star ratings!

### KeepWatch by InterWorks

Whether you need support for one platform or many, our technical experts have you covered.

## Raphael Teufel

Unlocking the Next Level of Data-Enabled Decision Making What Is Data-Enabled Decision Making? It’s actually easier to start with what it is not. It’s not making decisions based on a, “gut ...
Der ultimative Guide zu Year-over-Year-Vergleichen in Tableau Eine der häufigsten Aufgaben, die Dir begegnen können, wenn Du mit Tableau arbeitest, ist Daten über Zeiträume zu vergleichen. Jede ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×