To change pie chart angle order so it would suit gauge chart, we need to create **supporting data** that will make new angles.

**Sections** |

Zero_To_Value |

Value_To_50 |

After_50 |

Remainder |

Bottom Half |

We **add** column ‘Number of Records’ and enter ‘1’ **for** **every section row**. Also, we **do the same** with **whatever data** for which we want to create gauge charts. You can do this addition in Excel easily. This will allow those rows cross-join, when doing FULL-OUTER join on ‘Number of Records’=’1’ in Tableau Data Source window. As a result, we will have 5 different sections for each row of our data-set.

We are going to create a gauge chart that will represent Free Throw percentage of NBA players. Lets use 2018-2019 season stats from https://www.basketball-reference.com.

Now we **create calculated fields**.

**[Max %]**– Free Throw Percentage Value based on each player

**MAX({FIXED [Player]:MAX([FT%])})**

**[Arc Angle]** – Logical calculations needed to transform our percentage value so that it will be represented in upper half of a circle.

**CASE ATTR([Sections])**

**WHEN “Zero_To_Value” THEN IF ([Max %])<= 0.5 THEN ([Max %])/2 ELSE 0.25 END**

**WHEN “Value_To_50” THEN IF ([Max %])<= 0.5 THEN (0.5-[Max %])/2 ELSE 0 END**

**WHEN “After_50” THEN IF ([Max %])> 0.5 THEN (([Max %])-0.5)/2 ELSE 0 END**

**WHEN “Remainder” THEN IF ([Max %])<= 0.5 THEN 0.25 ELSE (1-([Max %]))/2 END**

**WHEN “Bottom Half” THEN 0.5**

**END**