You can write the join directly in the custom query or export your custom query into csv and then create a new data source and do the union. or run the query as stored procedure to save it in view or table and then use that instead. Hope that helps.
Thanks - enjoyable tutorial! I needed to use circular stats for a recent research project and eventually used a handy app called Oriana to produce graphs, which doesn’t require all of the calculation work that Tableau needs, but your output is much prettier. FYI, the use-case for circular stats is of course date-time as they mimic the cyclical nature of a clock, or of the seasons, but when you plot a data series of 4 continuous years, the result is inaccurate because Dec-2021 doesn’t in reality flow back into Jan-2018. If you remove the Group By on Year then you have an accurate graph
Hi Chris, Thanks for your feedback. I am not clear about what you meant by "Dec 21 doesn't really flow back to Jan-18" Could you please elaborate. Thanks
After plotting X and Y ,Once I change compute to month in my dataset, and convert mark to line ,I am only able to see the up and down lines not the circular shape in between , Can you please let me know how to solve this issue
Fantastic tutorial. Tried several guides and yours is the one that is most elegant. If I want to add annotation lines to demarcate the years, for example, how might I go about doing it? Looking forward to more advanced plots!
Thanks Glenn :-) Once way to add the Year is by bringing the "Year" field in to Text Mark and do the formatting in the text mar window. Second way is to bring the text value or image in a floating container to show the annotation. First way is more ideal and as a best practice its better to show annotation if there are less points or years otherwise it will overlap. Hope that helps.
Just a quick question please - I added labels to display amount on the chart. Trouble is tableau will place values on the outer radius and inner radius. Is there a quick way to disable values showing in the inner radius without having to deselect each values one by one?
Hi Wendy, Please try selecting the text mark and select Mark to labels at Line Ends.Then you can choose the options to allow labels to overlap or show at start of line or end of line. Hope that helps. Cheers!
Hi Pragathi, that’s a good question. For this chart we are creating two circles I.e inner and outer circle with same data set but different radius so we used union. I haven’t tried it without using unions but it might be possible using bins and data densification techniques, that might work.
this is incredible. by far one of the best walkthrough vids I've watched!! Thank you so much for uploading this!! Question - if I was using superstore products for each line but wanted the region for color - how would I go about doing that?
Thanks Joseph, appreciate your feedback. It should work the same way as shown in the tutorial. Could you please share your dashboard link and I can have a look and advice in case of any issues. Cheers! Gurpreet
Nicely broken down! Quick question if you see this, why did you have to use AVG([Angle Increment]) instead of just [Angle Increment] for the Angle calculation?
Hi Josh, that a great question. We used avg(Angle Increment) because there are multiple records for month year at granular/detail level and for our Angle calculation we need the data to be aggregated. That why we used Avg. If you check the table create at 12:52, you will see how the Angle value for each month is created. If you bring category in the row shelf, you will see multiple rows for each month year. Thats why we need to aggregate it else it will give error that it can't mix aggregate and non aggregate values Hope that helps. Cheers!
You can create the circular bar chart the same way but increase the inner radius greater than the outer radius of previous chart. Then place the second chart on top of first one in the dashboard. It will work fine. Hope that helps.
How can i fix the centre point of circle. I'd created a circular chart using this tutorial. The issue is on selecting the filter the chart start moving up and down. How can i fix it's centre point?
Hi Muhammad, Thats a great question. The centre point is same all time. When you change the filter values the axis range changes due to which the circle appears to move up and down. If you fix the axis then your issue will be resolved. Please try and let me know if you need more info. Hope that helps Cheers! Gurpreet
The best video on Circular Bar Chart.
Today I implemented it.
Thanks so much for your dedication and content.
Thanks for your feedback and supporting my channel. Please subscribe my channel and stay tuned for more such videos.😊
@@DataVizCanvas It is already done. :)
We are excited about your new videos 😊
The way your representing is awesome..
Keep posting this kind of videos.
Thanks KB prasad. Stay tuned for more such videos 🙏
Such a beauty!! Great piece of work. Kudos
Thanks 🙏
Hello! Thank you so much for the video!
You are welcome 🙏🏽
Glad you found it useful 😊
Is there a way to do this when using a custom sql query as the data source? I can't union sql queries so this becomes impossible
You can write the join directly in the custom query or export your custom query into csv and then create a new data source and do the union. or run the query as stored procedure to save it in view or table and then use that instead. Hope that helps.
Very good video, thanks!
Thanks 🙏🏽 Karel
Thanks - enjoyable tutorial! I needed to use circular stats for a recent research project and eventually used a handy app called Oriana to produce graphs, which doesn’t require all of the calculation work that Tableau needs, but your output is much prettier. FYI, the use-case for circular stats is of course date-time as they mimic the cyclical nature of a clock, or of the seasons, but when you plot a data series of 4 continuous years, the result is inaccurate because Dec-2021 doesn’t in reality flow back into Jan-2018. If you remove the Group By on Year then you have an accurate graph
Hi Chris,
Thanks for your feedback.
I am not clear about what you meant by "Dec 21 doesn't really flow back to Jan-18"
Could you please elaborate. Thanks
After plotting X and Y ,Once I change compute to month in my dataset, and convert mark to line ,I am only able to see the up and down lines not the circular shape in between , Can you please let me know how to solve this issue
Could you please share the twbx file and i can have a look. Seems like the path field is not working as expected..
Fantastic tutorial. Tried several guides and yours is the one that is most elegant. If I want to add annotation lines to demarcate the years, for example, how might I go about doing it?
Looking forward to more advanced plots!
Thanks Glenn :-)
Once way to add the Year is by bringing the "Year" field in to Text Mark and do the formatting in the text mar window.
Second way is to bring the text value or image in a floating container to show the annotation.
First way is more ideal and as a best practice its better to show annotation if there are less points or years otherwise it will overlap.
Hope that helps.
Just a quick question please - I added labels to display amount on the chart. Trouble is tableau will place values on the outer radius and inner radius. Is there a quick way to disable values showing in the inner radius without having to deselect each values one by one?
Hi Wendy, Please try selecting the text mark and select Mark to labels at Line Ends.Then you can choose the options to allow labels to overlap or show at start of line or end of line. Hope that helps. Cheers!
can we create this chart using single data source without performing union?
Hi Pragathi, that’s a good question. For this chart we are creating two circles I.e inner and outer circle with same data set but different radius so we used union.
I haven’t tried it without using unions but it might be possible using bins and data densification techniques, that might work.
this is incredible. by far one of the best walkthrough vids I've watched!! Thank you so much for uploading this!!
Question - if I was using superstore products for each line but wanted the region for color - how would I go about doing that?
Thanks Joseph, appreciate your feedback.
It should work the same way as shown in the tutorial. Could you please share your dashboard link and I can have a look and advice in case of any issues.
Cheers!
Gurpreet
Commendable and Thank youu
🙏you are welcome 🙏
Nicely broken down! Quick question if you see this, why did you have to use AVG([Angle Increment]) instead of just [Angle Increment] for the Angle calculation?
Hi Josh, that a great question.
We used avg(Angle Increment) because there are multiple records for month year at granular/detail level and for our Angle calculation we need the data to be aggregated. That why we used Avg.
If you check the table create at 12:52, you will see how the Angle value for each month is created. If you bring category in the row shelf, you will see multiple rows for each month year. Thats why we need to aggregate it else it will give error that it can't mix aggregate and non aggregate values Hope that helps.
Cheers!
Well done.
Thanks :-)
How can I make multiple layers in Circular bar chart? (i.e., they share the same inner circle)
You can create the circular bar chart the same way but increase the inner radius greater than the outer radius of previous chart. Then place the second chart on top of first one in the dashboard. It will work fine. Hope that helps.
How can i fix the centre point of circle. I'd created a circular chart using this tutorial. The issue is on selecting the filter the chart start moving up and down. How can i fix it's centre point?
Hi Muhammad,
Thats a great question.
The centre point is same all time. When you change the filter values the axis range changes due to which the circle appears to move up and down. If you fix the axis then your issue will be resolved.
Please try and let me know if you need more info.
Hope that helps
Cheers!
Gurpreet
Thank you
You are welcome. Glad you find it useful 😊