Chartbusters: Gauge Chart in Tableau

Подписаться 3,4 тыс.

Просмотров 99 тыс.

50% 1

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

Опубликовано:

3 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 62

@BrunoOliveira-zv9bi 3 года назад

The best explanation I have found so far. Congratulations. Great work.

@adrianpuentez 3 года назад

Wow, one of the best tutorials video I have seen in RU-vid. Thanks and keep up the great work!

@inadiv 3 года назад

This explanation and method is next level coding skills made easy.

@Tro_unce 3 года назад

This is the most well explained step by step process. Thank you very much for this.

@hongngannguyenthi1346 Год назад

I think this is very easy to follow what you shared.

@ezhankhan1035 9 месяцев назад

This is an Excellent Tutorial - Thank You!

@tuliopuertes3323 Месяц назад

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

@rinso1rojas128 Месяц назад

What you meant by [G_revenue]/AOP? Also do you have any solution if the profit percent is negative?

@tejusurs 29 дней назад

@@rinso1rojas128 replace the [G_REVENUE / AOP] with [Profit Percent] or the actual measure you are using and it should work.

@maryclairehermoso7196 11 месяцев назад

This is really helpful, thanks a lot!

@chandrakumarreddyvennapusa7806 3 года назад

Thanks for sharing information:) Great video

@FPrimeHD1618 2 года назад

Damn, this video is on point. Amazing tutorial!

@luisochoa5493 7 месяцев назад

Wow, Your are the best

@shanenicholson94 2 года назад

This is so good. Very easy and great tutorial!

@CynthiaRodriguez-rr6vn Год назад

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?

@ROROTORRESXD 2 года назад

You're the best thank you

@brendensong8000 3 года назад

Thank you for sharing!

@syedyousufsohail5773 4 года назад

Thanks Alot

@namanjain8164 Год назад

Hi, my label is shown 4 times above gauge also. How to correct that?

@learnviz4885 2 года назад

Great description, could you please help to create -100% to 100% meaning to say middle point will be 0%??

@tonylu718 2 года назад

Very nice and detailed, thank you! Is it possible to add a target/goal line, say 80%?

@SimplyJuline 7 месяцев назад

this was helpful, is there a way to filter to only see one of the gauge charts instead of all 3?

@CastleChuck 3 месяца назад

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!

@monikabishtt Год назад

How to create the same chart just to display the Average?

@sreeadhikary4134 5 месяцев назад

If the profit is null value what will be the calculation for gauge chart??

@sreeadhikary4134 5 месяцев назад

If the profit is null value what will be the calculation for gauge chart??

@jstewart_1 3 года назад

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...

@Nicesoftwaresolution 3 года назад

Try to use one Chart on a single sheet, to utilize maximum space in the sheet

@Booth72 3 года назад

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.

@divyasreedijesh1166 3 года назад

Good video. Thank you for sharing. Can u pls share advanced charts in tableau

@TheZharvey 2 года назад

Great tutorial. Is there a quick way to reproduce multiple charts with different goals or do i have to recreate all the formulas?

@ScottCLHimmelrich 3 года назад

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

@Nicesoftwaresolution 3 года назад

Try changing the aggregation, if you are getting different results.

@inadiv 3 года назад

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.

@matthewmucius5078 3 года назад

@@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.

@matthewmucius5078 3 года назад

Hi Scott, were you able to remedy this issue? I'm having the same issue.

@ralucapopa9575 3 года назад

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

@Nicesoftwaresolution 3 года назад

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

@doychindoychev1910 3 года назад

Great video! However t the end the formatiing is way too quick and one can miss something. Thanks and keep going!

@Nicesoftwaresolution 3 года назад

Thank you for the Feedback! We try to show all the essential formatting steps clear.

@wojtekpekrul6612 3 года назад

What can I do to keep the graph stop painting if the value is above 100%?

@winaykumar_m 3 года назад

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

@dhruvsharma9065 3 года назад

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

@residentsweetie 3 года назад

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! 🙏

@AbhishekTiwari-vf9ru 8 месяцев назад

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.

@deadsoul67 3 года назад

This is amazing! Is there a way to add in negative values?

@learnviz4885 2 года назад

did you get any solution for negative ?

@islamelkhateeb6524 3 года назад

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

@Nicesoftwaresolution 3 года назад

Show the Target highlighted in a separate color. Like in this case we have used the color "Grey".

@stephencurry6325 2 года назад

I'M getting error in the formulas

@kusaadigarla75 3 года назад

Needle is not working(Not changing dynamically)...its showing static pointer at 50% for every dimension value(Exp: region dimension South, east, west, north)

@Nicesoftwaresolution 3 года назад

Make sure the formula for Pointers is "IF [Profit Percent]

@yashinmehta4801 4 года назад

Thanks for the video , Can we increase the width of Needle ?And also can we create the Multicoloured Gauge .

@Nicesoftwaresolution 3 года назад

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

@ilhamfahtur9725 8 месяцев назад

@Nic😊😊😅esoftwaresolution 😅😅😅😊😊😊😊9

@sugarbean6218 3 года назад

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?

@sugarbean6218 3 года назад

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

@1112itachi 2 года назад

@@sugarbean6218 I follow your solution, however bootom half is not correct

@deeptigujralgrover4293 4 года назад

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