11 Replies Latest reply on Jun 3, 2018 2:45 PM by Ken Flerlage

# Radial, X , Y - Who Define Values

All,

I have downloaded around 7-10 tableau workbooks from the tableau public and navigated all the sheets/properties. While Viewing the data, I can see Radial, X, Y and it is used (in most cases) as AVG(X), AVG(Y) either in column or Row.

The numbers for Radail, X & Y are something like 0.12, 0.34, 0.123.

My questions are

1) Do we get these number in the requirements?

2) Do we need to generate these numbers based on the report? If yes, what is the steps to generate the values for X, Y and Radial

3) I have also seen PathID (for Line), again how to generate these numbers?

4) In all their reports, have they created these numbers ?

5) Say for example, I want to show my report in circular format, how to define the numbers for X,Y and PathID ? is it based on Circle size?

I am totally blur on this area, some useful tips/help would really clear my vision.

I looked into the below report in my tableau desktop, and the data used in this report is attached here.

In the attached excel sheet, I am talking about column U & V.

SNAPSHOT OF U & V below.

 X Y 60.99976 0.171104 118.9995 0.333794 118.9981 0.667585 118.9958 1.001371 118.9925 1.335149 419.9736 4.71229 419.9587 5.890293 419.9405 7.06825 419.919 8.246151 419.8943 9.423987 419.8662 10.60175 419.8348 11.77943 419.8001 12.95701
• ###### 1. Re: Radial, X , Y - Who Define Values

any thoughts ?

I also thought of displaying data in a star format. is it possible in Tableau?

• ###### 2. Re: Radial, X , Y - Who Define Values

Can you clarify the question? I don't really understand what you're asking.

• ###### 3. Re: Radial, X , Y - Who Define Values

I mean  i would like to draw STAR kind of picture and need to put some data points in the edges of the starts.

I think I deviated from my original question, but this is also want to ask, that's why asked in the same thread.

• ###### 4. Re: Radial, X , Y - Who Define Values

I'm still not sure I understand what you're trying to do, but let me try to answer your question. Harpreet's March Madness viz likely used trigonometry to draw polygons. I haven't looked at his viz specifically, so he may have calculated the x and y coordinates outside of Tableau.

To draw the star, you could also potentially use some basic trig. You'd calculate the coordinates of the outer points using one radius and the coordinates of the inner points using another. Another option would be to use the Drawing Tool for Tableau - Power Tools for Tableau  to trace the star and create your coordinates.

If desired, I'm happy to create a workbook that does the calculations for you.

• ###### 6. Re: Radial, X , Y - Who Define Values

Yes Ken, Seems he calculated X and Y outside the tableau, I wanted to understand that piece only.

I have asked to place fruits in a circular path and got good answer from

• ###### 7. Re: Radial, X , Y - Who Define Values

I'll see if I can work something up for the star layout. Might be a day or two before I can do that though.

Regarding the circle stuff you noted on your other post, I wrote a blog about using trig in Tableau which may be of value to you: Beyond "Show Me" Part 2: Trigonometry - Ken Flerlage: Analytics Architecture, Strategy, & Visualization

• ###### 8. Re: Radial, X , Y - Who Define Values

Attached is a packaged workbook showing how to create a star. The source data set is very simple--a single column called Point ID with 11 records, one for each point on the star (the 11th point is the same as the 1st point so that we can connect the final line). The workbook just uses trigonometry as I explain in my blog post.

• ###### 9. Re: Radial, X , Y - Who Define Values

Thanks Ken! It is really good and useful. I will read your blog and come back with some questions.

I just tried square and some cross lines inside the square, note I hard coded the  X & Y for now just to understand the concept.

I have to implement the mathematical approach to calculate X & Y. Incase if there is any change in the approach (planning to implement Star, circle steps) please give some tips.

Please go through the attached twb file and let me know.

• ###### 10. Re: Radial, X , Y - Who Define Values

What exactly are you trying to do with this one?

• ###### 11. Re: Radial, X , Y - Who Define Values

Any further questions on this, Karthikeyan? If not, can you mark one of these answers as correct? If so, what other issues are you having?

1 of 1 people found this helpful