Hi Edgar. Happy to help. Can you share some sample data and perhaps show how far you've gotten so far by attaching a packaged workbook?
Hi Finally i can do the gauge i understand better how it works but, could you explain me how i can use it on my own data please?
I have a excel with 80, 000 rows and i want have this representation.
Book3.twbx 19.8 KB
Sorry for the delay on this. Let's say you have some data like this:
You'll need to start by cross-joining this to the slices data. A cross-join will match each record in one data set with each record from the other data set. We can do this with a 1=1 join calculation (see the cross join section of the following blog for more details: https://www.kenflerlage.com/2018/09/sql-part2.html).
Next, we need to update our calculated fields to use the sample data's percentage (the field is called Value). You'll need to swap Value for Percentage in the following fields:
And you'll need to drag the new Value field to the text card on the second axis, replacing Percentage:
Finally, since the gauge can only show a single percentage at a time, we'll want to filter on our "Things". The end result should look something like this:
Workbook and source Excel file are attached.
Thanks, that helps me a lot
No problem. My apologies for not explaining it better in the blog. I've actually added a link at the end of the blog to point back to here in case others run into the same problem.
Hi Ken Flerlage,
Your post really nice. I am new to Tableau. Trying to implement similar like gauge meter scenario with your same sample record.
For that, I am trying to explore the same your gauge meter chart. But, Some how I am failing, while adjusting the Size of the Circle.
Attached my Tableau book. Hope that, if you look it, you may identify where I am missing. Kindly, help on this.
Thanks in Advance.
Book1.twbx 21.4 KB
In addition to this, you need to do a couple of other things:
1) Synchronize your axes.
2) On the first axis, move the Slice # pill above the Color pill so that it sorts by the slice instead of the color, by default.
3) Increase the size.
4) Change the colors as apporpriate.
5) Set the label alignment to middle/centered.
Thanks Edgar. Got it.
Now, I got it. Thanks Ken Flerlage.