Create a Circular Progress Chart (Orbit Chart) with Rounded Ends in Tableau by using unionized data, sine and cosine functions for X and Y coordinates, and a dynamic parameter to set a goal for progress tracking. Enhance your dashboards with precise color coding based on completion percentage, resulting in an interactive and visually compelling progress indicator.
Tableau: https://public.tableau.com/app/profile/samantha.cohn/viz/BeyondBasicChartsSalesOrderInsightsSuperstoreData/Dashboard1
Excel: Superstore data set (built into Tableau)
Formulas:
Orbit Points: IF CONTAINS([Table Name], "1") THEN 1 ELSE 360 END
Orbit - X: SIN(RADIANS(INDEX()))
Orbit - Y: COS(RADIANS(INDEX()))
Orbit - % Complete: WINDOW_SUM(SUM([Sales]))/2 / [SALES GOAL]
Orbit - Colors: IF INDEX()/WINDOW_MAX(INDEX()) less than [ORB - PER COMPL (copy)]
THEN 1 ELSE 0 END
Download
0 formats
No download links available.
Create a Circular Progress Chart (Orbit) with Rounded Ends in Tableau | NatokHD