Here is a fun way to accentuate if your team made their sales goals in a simple table in Tableau. In my blog two weeks ago, I mentioned a way to create a simple table view using the min(0) calc.

This article and last week's was inspired by **Luke Stanke's **"26 Ways to Enhance your Tables" __here__. I just modified the calculations slightly for both articles.

**How to Add Stars**

What if your client wanted to display a three point star system based on the following Sales criteria;

If Sales for the last month were greater than 10,000 then three stars should appear next to the metric. If Sales were from 7000 - 9999 then two stars should appear next to the metric. If the Sales were greater than 4000 then one star and all others with no stars.

This view is available in my public dashboard** **__here__**. **

Here is the calculated field to represent this criteria. I used the star icon from the Windows Character map. (Google it if you can't find it.)

**Sales Stars**

If Sum([Sales Current Month]) > 10000

THEN "★★★"

ELSEIF Sum([Sales Current Month]) > 7000

then "★★"

ELSEIF Sum([Sales Current Month]) > 4000

then "★"

ELSE ""

END

There are a couple of other calculations I used to create the most recent month of data;

**Current Month**

[Order Date] >= DATEADD("month",-1,DATETRUNC("month",{MAX([Order Date])}))

AND

[Order Date] < DATETRUNC("month",{MAX([Order Date])})

***Sales Current Month**

If [Current Month]

THEN [Sales]

END

*I created this calculation for all of the metrics, Quantity, Profit Ratio, Profit.

I set up my Tableau workbook using the Min(0) calculation for each of the metrics as advised in my last blog __here__.

The only change is that I made a dual axis calculation for the **Sales** and fifth min calculation. I also placed the **Sales Stars** calculation on this **Marks** card.

I also changed the **Chart Type** to **Gantt** for all of the metrics. I changed the blue line to white to hide it. This allows for the **Stars** to be right next to the metric with a little gap in the dashboard.

I also adjusted the alignment of the text for the **Sales Current Month **metric to **Middle Left** and **Middle Right **for the stars.

**How to Add Circles**

What if you wanted to show three circles. Some that are empty and some that are filled? This is in my public dashboard** **__here.__** **

I used the following calculations for this;

**Circles**

If Sum([Sales CM]) > 10000

THEN "●●●"

ELSEIF Sum([Sales CM]) > 7000

then "●●"

ELSEIF Sum([Sales CM]) > 4000

then "●"

ELSE ""

END

**Circles Empty**

If Sum([Sales CM]) > 10000

THEN ""

ELSEIF Sum([Sales CM]) > 7000

then "○"

ELSEIF Sum([Sales CM]) > 4000

then "○○"

ELSE "○○○"

END

The reason there are two different calculations here is if you want your clear circles to be a different color than your filled circles.

I placed both of these calculations on the newly created fifth **Min(0) **pill. I placed them side by side.

They should make the **Sales** column appear as below;

You can also change the color of the stars or the circles with the Color Marks card.

## Commentaires