Thank you very much for the video For Colored>50% and Grey>50% i did some additions for those cases that reaches something beyond 100% Colored>50% IF [Profit Percent] >1 THEN 0.5 ELSEIF [Profit Percent] >0.5 THEN [G_REVENUE / AOP] - 0.5 END Grey>50% IF 1 -[Profit Percent] < 0 THEN 0 ELSEIF [Profit Percent] >0.5 THEN 1- [Profit Percent] ELSE 0.5 END
Is there a way to have 3 sections eg 85% = green? Whenever i try tweaking what we have here I keep causing the gauge to rotate in an anticlockwise direction. Thanks for the video!
So I've got issues with this trying it - when I move Measure Values to Angle, Bottom Half becomes AGG, the rest SUM....I'm not sure if this is going to be an issue, but I don't get the same outcome, so I assume it's an issue
Had same problem. Double click and manually erase SUM and switch to AGG. need to make sure you are using a calculated field that SUMs the product categories for example.
@@Nicesoftwaresolution I'm having the same issue where the Measure Values are coming out as SUM instead of AGG and I'm not getting the same numbers. The bottom half is showing on my sheet.
Hi Can you please share a link or something to understand how this all works if we add more bifurcation i.e. 0-33, 33-66 and 66+, instead of 2 as shown in video
Hi Team, how to create such charts when there are negative percentages too? I tried to create it but, the pointer and the colored pie doesn't align correctly and changing the color calculation is affecting the pointer too
Please help. I'm trying to recreate this with whole numbers (1-10), where 0-8 is green, 9-10 is Amber and over 10 is red. But the donut is lopsided. Please help! 🙏
Hi, Very useful. Thank you very much :) can you also give some insights what should be changed to have the 100% in the middle and on the left 50% and right 150%? thanks
Such kind of a scale will be suitable only if all the data points lies between 50% - 150%. Try to use +0.5 in all the formulas and hide -0.5 to 0.5 by coloring it white
Great video, it really helped with my project, however I have an issue: I have some months that the gauged field (Profit Percent in your video) is more than 100%, and the visualization shows the grey area on the 1 amount, the bottom half moves up the left side (9 O'clock position, if you will, to a 10 o'clock position). Any recommendations on how to fix this?
I fixed it. For anyone who may also have this problem, I modified the Grey > 50% calculation to: IF [Profit Percent] > 0.5 AND < 1 THEN 1 - [Profit Percent] ELSEIF [Profit Percent] > 1 THEN 0 ELSE 0.5 END And then I modified the Bottom Half calculation as well to keep it from creeping up the other side as follows: IF [Profit Percent] > 1 THEN 2 - [Profit Percent] ELSE MIN(1) END
This looks nice, however, when placing in dashboard with tooltips on the bottom half of the circle is selectable (confused audience) and when resizing (without floating objects) the gauge takes up quite a bit of space as the object reserves the space for the bottom circle.... Tableau really needs to add gauges as part of their out-of-the-box visuals... gauge charts seem pretty industry standard...
Hey James. I have a solution. At Step1 when creating the Calculated field in the Rows. Type 10 instead of 0 for both. Then Edit both axis with a fixed start point of 10. It will push the bottom half of the guage out of site.
Needle Size can be increased by increasing the overall size of the Chart & Instead of using same colors, you can use different colors for different range of values. Hint: Make a separate calculated field for each Range
Amazing, thank you so much - but how to visualize the target in the same gage chart, let say the target profit for whole group is 65% Thanks in advance
Needle is not working(Not changing dynamically)...its showing static pointer at 50% for every dimension value(Exp: region dimension South, east, west, north)
Hi, thanks for the video, can we also add labels to the gauge at regular intervals like 0, 20,40,60,80 100? This is my requirement, request you to please provide a solution if possible
The best explanation I have found so far. Congratulations. Great work.
I have a question I was able to recreate your dash but I cant seem to be able to place the labels inside the gauges? can you provide guidance?
Wow, one of the best tutorials video I have seen in TH-cam. Thanks and keep up the great work!
I think this is very easy to follow what you shared.
This explanation and method is next level coding skills made easy.
This is the most well explained step by step process. Thank you very much for this.
This is an Excellent Tutorial - Thank You!
this was helpful, is there a way to filter to only see one of the gauge charts instead of all 3?
Thank you very much for the video
For Colored>50% and Grey>50% i did some additions for those cases that reaches something beyond 100%
Colored>50%
IF [Profit Percent] >1
THEN
0.5
ELSEIF [Profit Percent] >0.5
THEN
[G_REVENUE / AOP] - 0.5
END
Grey>50%
IF 1 -[Profit Percent] < 0
THEN
0
ELSEIF
[Profit Percent] >0.5
THEN
1- [Profit Percent]
ELSE
0.5
END
What you meant by [G_revenue]/AOP?
Also do you have any solution if the profit percent is negative?
@@rinso1rojas128 replace the [G_REVENUE / AOP] with [Profit Percent] or the actual measure you are using and it should work.
Is there a way to have 3 sections eg 85% = green?
Whenever i try tweaking what we have here I keep causing the gauge to rotate in an anticlockwise direction.
Thanks for the video!
Hi, my label is shown 4 times above gauge also. How to correct that?
Very nice and detailed, thank you! Is it possible to add a target/goal line, say 80%?
This is really helpful, thanks a lot!
Damn, this video is on point. Amazing tutorial!
Great description, could you please help to create -100% to 100% meaning to say middle point will be 0%??
So I've got issues with this trying it - when I move Measure Values to Angle, Bottom Half becomes AGG, the rest SUM....I'm not sure if this is going to be an issue, but I don't get the same outcome, so I assume it's an issue
Try changing the aggregation, if you are getting different results.
Had same problem. Double click and manually erase SUM and switch to AGG. need to make sure you are using a calculated field that SUMs the product categories for example.
@@Nicesoftwaresolution I'm having the same issue where the Measure Values are coming out as SUM instead of AGG and I'm not getting the same numbers. The bottom half is showing on my sheet.
Hi Scott, were you able to remedy this issue? I'm having the same issue.
Great tutorial. Is there a quick way to reproduce multiple charts with different goals or do i have to recreate all the formulas?
This is so good. Very easy and great tutorial!
Wow, Your are the best
Thanks for sharing information:) Great video
Hi Can you please share a link or something to understand how this all works if we add more bifurcation i.e. 0-33, 33-66 and 66+, instead of 2 as shown in video
If the profit is null value what will be the calculation for gauge chart??
Hi Team, how to create such charts when there are negative percentages too?
I tried to create it but, the pointer and the colored pie doesn't align correctly and changing the color calculation is affecting the pointer too
How to create the same chart just to display the Average?
What can I do to keep the graph stop painting if the value is above 100%?
Please help. I'm trying to recreate this with whole numbers (1-10), where 0-8 is green, 9-10 is Amber and over 10 is red. But the donut is lopsided. Please help! 🙏
hi All,
Can any one share the twbx file or tableau public link of the above dashboard. I am unable to get the desired solution with my dataset.
Hi, Very useful. Thank you very much :) can you also give some insights what should be changed to have the 100% in the middle and on the left 50% and right 150%? thanks
Such kind of a scale will be suitable only if all the data points lies between 50% - 150%. Try to use +0.5 in all the formulas and hide -0.5 to 0.5 by coloring it white
Great video, it really helped with my project, however I have an issue: I have some months that the gauged field (Profit Percent in your video) is more than 100%, and the visualization shows the grey area on the 1 amount, the bottom half moves up the left side (9 O'clock position, if you will, to a 10 o'clock position). Any recommendations on how to fix this?
I fixed it. For anyone who may also have this problem, I modified the Grey > 50% calculation to:
IF [Profit Percent] > 0.5 AND < 1
THEN 1 - [Profit Percent]
ELSEIF [Profit Percent] > 1
THEN 0
ELSE 0.5
END
And then I modified the Bottom Half calculation as well to keep it from creeping up the other side as follows:
IF [Profit Percent] > 1
THEN 2 - [Profit Percent]
ELSE MIN(1)
END
@@sugarbean6218 I follow your solution, however bootom half is not correct
Thank you for sharing!
This looks nice, however, when placing in dashboard with tooltips on the bottom half of the circle is selectable (confused audience) and when resizing (without floating objects) the gauge takes up quite a bit of space as the object reserves the space for the bottom circle....
Tableau really needs to add gauges as part of their out-of-the-box visuals... gauge charts seem pretty industry standard...
Try to use one Chart on a single sheet, to utilize maximum space in the sheet
Hey James. I have a solution. At Step1 when creating the Calculated field in the Rows. Type 10 instead of 0 for both. Then Edit both axis with a fixed start point of 10. It will push the bottom half of the guage out of site.
You're the best thank you
Good video. Thank you for sharing. Can u pls share advanced charts in tableau
Thanks for the video , Can we increase the width of Needle ?And also can we create the Multicoloured Gauge .
Needle Size can be increased by increasing the overall size of the Chart & Instead of using same colors, you can use different colors for different range of values. Hint: Make a separate calculated field for each Range
@Nic😊😊😅esoftwaresolution 😅😅😅😊😊😊😊9
Amazing, thank you so much - but how to visualize the target in the same gage chart, let say the target profit for whole group is 65% Thanks in advance
Show the Target highlighted in a separate color. Like in this case we have used the color "Grey".
Needle is not working(Not changing dynamically)...its showing static pointer at 50% for every dimension value(Exp: region dimension South, east, west, north)
Make sure the formula for Pointers is "IF [Profit Percent]
Hi, thanks for the video, can we also add labels to the gauge at regular intervals like 0, 20,40,60,80 100? This is my requirement, request you to please provide a solution if possible
you ever figure this out? If so, please share
This is amazing! Is there a way to add in negative values?
did you get any solution for negative ?
Great video! However t the end the formatiing is way too quick and one can miss something. Thanks and keep going!
Thank you for the Feedback! We try to show all the essential formatting steps clear.
Thanks Alot
I'M getting error in the formulas
If the profit is null value what will be the calculation for gauge chart??