TABLEAU RADIAL PIE GAUGE CHART TUTORIAL 

Thanks for coming Jean.

You are most welcome Belen!

Thanks for your inquiry. To rotate the chart, you will need to change the calculations for the X and Y fields. I will check the solution to this request and update this thread.

Simply force wc_start to be negative. - WINDOW_MAX(MAX([Order]))

You are most welcome Maged!

Hi Rishiraj, Glad to hear you are enjoying the tutorials! With this chart, I would suggest to keep the number of items to be displayed relatively small, and therefore your approach for the top n items is good. As for the implementation part, I would suggest you complete all of your prep before (or if possible) in your datasource as this method is quite limiting in its application inside the actual chart. Best of luck!

I am very new to Talbeau but my guess if we will be building an inner and outer ring for the data for each response and we need them to track.

Hi Mohammed, for this approach to work you will unfortunately have to use a Union or you could prepare the data outside of Tableau up to the Union.

Thanks..!

Hi Srikanth, Thanks for adding to this thread. "Response" is a measure not a function. You can use this measure by right clicking it in the measures section and selecting calculated field. This will pre-populate the formula with the field name. Hope this helps

Hi Suhel, Thanks for adding to this thread. Please see our radial bar chart tutorial where we work with date based radials: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-d6-aptKLvgg.html

Hi Ghazal. Yes, you can build this into your data preparation and split the SQL line into more than one line and adjust as per the tutorial. You could also use the SQL version breakdown data as a secondary dataset and u show specific versions in a secondary graph on a dashboard.

Hi Beata, The example was created to work specifically with a 270-degree gauge as this allows us enough space for the labels and values. You need to ensure that your max value (I guess in this case the one that produces the 304 degrees), is "normalized" to the maximum allowed value) which will also then be applied to all the other values. You can see this put in place at 3:23 of the video.

SuperDataScience Thanks

Seems like you need to do more than that. What if I wanted these gages to all be relative to 100% or 360?

I wanted to see a complete circle as well. In the Path calc, replace 271 with 361. In the X and Y calcs, replace 270 with 360 and replace 540 with 720. Also, my Percentage calc is Response/100.

Hi Andrei. This is definitely possible with data from Salesforce, but you might first needs some data preparation. I would suggest to prepare the data as per the example, and use a Union to "duplicate" the data. If the Union is not possible, you could do this step also in your data preparation.

Thank you for your prompt reply. Regarding the preparation, i have direct connection to sfdc server which is more convenient for me i.e. automatically updates all the viz that i have. switching them to other source such as excel excludes this automation process. I know that its more easier to do it via excel as on example you show ( for which I thank you). Maybe you know another solution without doubling the data, because sfdc connection does not allow you to create custom query.

Hi Andrei. Unfortunately at the moment this is the only workable solution we have. Why not reach out to the Tableau Community to see whether someone has perhaps found a workaround.

Hi Mandar. In this case, and specifically using this method, I would suggest that you complete all data prep including the multiple tables, and then only proceed in crating the visualisation.

Hi madspringy. I have just tested it again on my v10.5, and it work perfectly. There must something else that is different then. I would suggest checking the formulas of calculated fields once again andalso ensure that the "Aggregate Measures" has been enabled.

Thanks for the reply and checking! ...will deffo check out "Aggregate Measures" first chance I get - wasn't aware of this option.

@@ArtofVisualization Hello, does this work in Tableau 10.3? If so, I am struggling with the "Path Calculation" and Bin. What exactly is the Path Calculation measuring? Is the "Table Name" the dimension you're trying to measure and display with the final graph? And then, it needs to = the 'data source' you're using, along with 1, 271? Because when input this, and try to create a Bin, it doesn't give me the same Bin it gives you. It gives me a Bin with 271 Min, 271 Max, Diff 0, and CntD 1. What am I doing wrong and how can I get the correct Bin? All the other calculations seem to be working. Thank you so much!

Hi Bindu, The only thing you really need to update is the Percentage field, ensuring that your last record ends up at 100% and therefore you will divide the "response" with the largest response value.

Thank you !! Got it

Really strange. Thanks for letting us know Fabio, we will check this out.

I am also facing same issue, any guess why its happening

Hey.. I got it , keep X in Columns and keep path bin in y , click on path bin and select show missing values and pull it back to detail .. it should work

I'll give it a try ASAP Thanks a lot in advance!

Hi Bindu, To implement both of these changes, you will need quite a bit of changes and further custom work to this approach. With this current approach you are limited to the current visual. If you do find an easy way to do this, please do share!

Hi Avijit, When increasing the values, you will also need to ensure that you update the maximum value in the "Percentage" calculated field accordingly.

Hi Lotanna, A table calculation is required to perform this function. Please see link on what/how table calculations work: onlinehelp.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm We also cover this within our Tableau courses: www.superdatascience.com/courses/tableau-2018-hands-on-tableau-training-for-data-science/

find the solution...use REPLACE function to change a , into a . for Tableau

Apologies Jean, just saw your comment. Glad to know that everything fixed now.

Maybe one day they will do it :)

Thanks for your comment Monte!

You are most welcome Toan!

Hi Shivaprasad, Thanks for adding to this thread. There are different correct ways to solve problems in Tableau, thank you for sharing your solution.