Chartbusters: Gauge Chart in Tableau
Вставка
- Опубліковано 14 жов 2024
- This video demonstrates how to create a Gauge chart to display Profit gained by each Category over Total profit using the Sample Superstore dataset. To know more applications of Gauge chart check our Tableau Public profile: public.tableau....
For further insights, reach out to info@nicesoftwaresolutions.com. Feel free to Like, Share, and Subscribe.
#chartbusters #tableau #nicesoftwaresolutions #gaugechart #dashboard #visualization #dataanalysis #tableaupublic #businessintelligence
The best explanation I have found so far. Congratulations. Great work.
Wow, one of the best tutorials video I have seen in UA-cam. Thanks and keep up the 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?
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 was helpful, is there a way to filter to only see one of the gauge charts instead of all 3?
This explanation and method is next level coding skills made easy.
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 an Excellent Tutorial - 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!
Very nice and detailed, thank you! Is it possible to add a target/goal line, say 80%?
Hi, my label is shown 4 times above gauge also. How to correct that?
This is really helpful, thanks a lot!
Great description, could you please help to create -100% to 100% meaning to say middle point will be 0%??
Damn, this video is on point. Amazing tutorial!
How to create the same chart just to display the Average?
Wow, Your are the best
Great tutorial. Is there a quick way to reproduce multiple charts with different goals or do i have to recreate all the formulas?
If the profit is null value what will be the calculation for gauge chart??
Thanks for sharing information:) Great 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
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.
This is so good. Very easy and great tutorial!
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.
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
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 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.
You're the best thank you
Thank you for sharing!
What can I do to keep the graph stop painting if the value is above 100%?
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
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! 🙏
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
This is amazing! Is there a way to add in negative values?
did you get any solution for negative ?
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
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
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".
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
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]
I'M getting error in the formulas
If the profit is null value what will be the calculation for gauge chart??