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.
First of all, great views with the NPS gauge. Been looking for a management dashboard with these type of meters.
I adjusted the meter to go from 0 to 100 instead of -100 to 100. Will have to tweak again for 0-25% values, but that is not the current issue.
I want to use them with our dataset, but our dataset is over 200 mio records. Which is an issue when joining the Slices, since the dataset becomes 5 times as large.
Do you have a solution for this?
I also would like to zoom on data and change the gauge accordingly. This results in multiple slides being visualized and the meter is not 180 degrees anymore.
TO clarify, see attached set as an example ( on groep dimension, is would expect ti to show the average of this dimension..
Can you help me
but with Group as selcetion
can you help me
Might be best to start a new thread for this, if you wouldn't mind.
I did is also on Tableau comm. As a reply on the original post
Mobile: +31 (0)6 231 47 46 5
This communication is intended only for use by the addressee. It may contain confidential or
privileged information. If you receive this communication unintentionally, please let us know
by reply immediately. RedShare does not guarantee that the information sent with this E-mail
is correct and does not accept any liability for damages related thereto.
image001.png 11.3 KB