1 2 Previous Next 29 Replies Latest reply on Jul 17, 2018 5:26 AM by Karthikeyan Masialamani

Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 3, 2018 9:57 AM

All,

I am planning to draw Gauge/Speedometer kind of full round with some major 5 partitions and inside those partitions 5 more partitions needs to added.

If I click any of these filters, I have 5 values.

1)<50$K

2)>50$K

3)>10$K

4)>200$K

5) Null

Now...I want to draw some circle char with 5 major area ( Project Benefit Thresholds, Project Costs Thresholds, Planned Benefit Thresholds, Planned Benefit Thresholds, Labor Actuals Threshold) and inside of each area , I need to display 5 portions ( which are listed above), If I click on say for example, Project Benefit Category AREA --> >200$K THEN RESPECTIVE PROJECT should be filtered.

I have designed this dashboard with the above basic format filter, now I want to upgrade it a single circular chart.

I have read lot of articles and found needs to setup X & Y co-ordinates for this, but don't know how exactly set the values for X & Y.

Inputs are highly appreciable!

1. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Ken Flerlage Jul 4, 2018 12:03 PM (in response to Karthikeyan Masialamani)

I'm having trouble following what you want to do. Any chance you could draw a sample of the desired output and share some data and/or packaged workbook?
Like Show 0 Likes(0)

Actions
2. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Chris McClellan Jul 5, 2018 11:33 PM (in response to Karthikeyan Masialamani)

Do you mean something like this ?

SUNBURST CHART TABLEAU TUTORIAL PART 1 - YouTube
Like Show 0 Likes(0)

Actions
3. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 6, 2018 6:40 AM (in response to Chris McClellan)

Chris

Thanks. I’m on vacation leave today, l will look at it later and get back to you
Like Show 0 Likes(0)

Actions
4. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 8, 2018 11:39 PM (in response to Karthikeyan Masialamani)

Actually the requirement is as below...

I have the status of project like Green, Red and Amber. I want to draw a half-circle like below where the half circle should be proportionally divided into 3 piece with 3 colors ( Green, Red & Amber). If I click on Green color then those projects needs to be filtered out and so on.

Got this image from : Use radar charts to compare dimensions over several metrics | Tableau Software
Like Show 0 Likes(0)

Actions
5. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 11, 2018 9:18 AM (in response to Karthikeyan Masialamani)

any help is highly appreciable!
Like Show 0 Likes(0)

Actions
6. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 11, 2018 9:22 AM (in response to Karthikeyan Masialamani)

as I can't give some realistic sample data, we can use sample data store here.

I would like to show

a) Furniture - Category under 'Green'
b) Office Supplies - Under 'Amber'
c) Technology - Under 'Red'
Like Show 0 Likes(0)

Actions
7. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 11, 2018 9:23 AM (in response to Karthikeyan Masialamani)

I can realize that I need to generate X, Y axis value for all the products based on category, but the problem is how , where to start? how to arrive the exact numbers? if any body just pulled my car little bit then it can start
Like Show 0 Likes(0)

Actions
8. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 11, 2018 9:26 AM (in response to Karthikeyan Masialamani)

Green can be proportionally divided in between 0 and 60
Amber can be proportionally divided in between 61 and 120
Red can be proportionally divided in between 121 and 180
Like Show 0 Likes(0)

Actions
9. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Ken Flerlage Jul 11, 2018 9:35 AM (in response to Karthikeyan Masialamani)

Perhaps take a look at the following

Creating NPS Gauges in Tableau - Ken Flerlage: Analytics Architecture, Strategy, & Visualization

Dueling Data: How To Create a Gauge Chart in Tableau (UPDATED)
I don't think either is exactly what you need, but they may
point you in the right direction
Like Show 0 Likes(0)

Actions
10. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 11, 2018 9:45 AM (in response to Ken Flerlage)

Thanks Ken, but I am looking for something like below ( constant one).

If I click on Green then project which are in Green status should be filtered and son on.
Like Show 0 Likes(0)

Actions
11. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Ken Flerlage Jul 11, 2018 9:58 AM (in response to Karthikeyan Masialamani)
Here's a method which works similarly to my NPS approach. It's a pie chart with the bottom half being all white. But, you can still click on the bottom half, which is a bit of a problem. One option would be to float a blank over top of it when you place it on your dashboard so that they can't click on the bottom. See attached data and workbook.

Another option is to draw the shape with polygons. I have a method for doing that as well, if you're interested. It's a bit more complex than the pie idea though.

Half Pie.twbx 15.1 KB

Half Pie Data.xlsx 10.7 KB
Like Show 0 Likes(0)

Actions
12. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 11, 2018 10:18 PM (in response to Ken Flerlage)

Ken,

I am getting below the error message, we are using 10.5. can you send the file according to this version?
Like Show 0 Likes(0)

Actions
13. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Karthikeyan Masialamani Jul 11, 2018 10:20 PM (in response to Karthikeyan Masialamani)

Ken,

I am interested to understand Polygon option. Can you share the polygon method with me?
Like Show 0 Likes(0)

Actions
14. Re: Full Round - Gauge/Speedometer Kind of Circular Chart

Ken Flerlage Jul 12, 2018 5:00 AM (in response to Karthikeyan Masialamani)
Here you go.

Half Pie_v10.5.twbx 15.1 KB
Like Show 0 Likes(0)

Actions