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
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.
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.
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, 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
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 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
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
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
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.
Wow, one of the best tutorials video I have seen in TH-cam. Thanks and keep up the great work!
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.
This is the most well explained step by step process. Thank you very much for this.
I think this is very easy to follow what you shared.
This is an Excellent Tutorial - Thank You!
This explanation and method is next level coding skills made easy.
Damn, this video is on point. Amazing tutorial!
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?
This is really helpful, thanks a lot!
this was helpful, is there a way to filter to only see one of the gauge charts instead of all 3?
Thanks for sharing information:) Great video
Very nice and detailed, thank you! Is it possible to add a target/goal line, say 80%?
This is so good. Very easy and great tutorial!
Wow, Your are the best
Hi, my label is shown 4 times above gauge also. How to correct that?
Great description, could you please help to create -100% to 100% meaning to say middle point will be 0%??
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.
How to create the same chart just to display the Average?
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.
You're the best thank you
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!
Did you find any answer for that ?
If the profit is null value what will be the calculation for gauge chart??
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
Good video. Thank you for sharing. Can u pls share advanced charts in tableau
Great tutorial. Is there a quick way to reproduce multiple charts with different goals or do i have to recreate all the formulas?
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! 🙏
What can I do to keep the graph stop painting if the value is above 100%?
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
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
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.
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.
Same here can you please tell if you have found any remedy for that
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
Thanks Alot
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]
This is amazing! Is there a way to add in negative values?
did you get any solution for negative ?
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
I'M getting error in the formulas
If the profit is null value what will be the calculation for gauge chart??