1 2 Previous Next 15 Replies Latest reply on Apr 19, 2019 1:17 PM by Ken Flerlage

# ARC diagram help

I have made an arc diagram using helpful tips I have found here in the forum.  The image in the upper left is what I am able to do, but I would like it to look like the image on the right.

I would like the x axis to be constant, and have the arc go up to each of the points.  Is this something that can be done in Tableau?  I've attached a packaged workbook with sample data. • ###### 1. Re: ARC diagram help

Hi Carrie,

Check out this viz here on building a jump plot.  I believe it'll help you achieve what you're looking for:

Best,

Paul

• ###### 2. Re: ARC diagram help

I played around with your formulas a bit, changing X and Y to the following:

X

((COS([Point] * PI() / 180)) + 1 )

Y

(((SIN([Point] * PI() / 180)) * [Week]))

That gives me this (I'm only showing weeks 1-10 so we can make sure it looks similar to the image you provided). Note: week 1 is on the bottom. If you wanted to reverse that then then we'd subtract Week from 53 in the Y formula above.

To get the dot at the top of each arch, we'll create a calculated field like this:

Dot Y

// Y coordinate of the dot we'll be placing at the top of each arc.

// Only return a value for the center point (90).

IF [Point]=90 THEN

[Y]

END

Then add that to the rows shelf as a dimension. Should look like this: On the second axis, change the mark type to a circle and increase the size a bit. Then right-click on the Dot Y pill and change the chart to a dual axis. Then, right click on the axis and choose "synchronize axis" Put it side-by-side with your original image and it looks pretty darn close!! (my chart is on the left). See attached workbook.

If this resolves your question, please be so kind as to mark my response as the "correct answer". This will allow us to close the thread and will make it easier for people with similar questions to find the answer in the future. Thanks!

• ###### 3. Re: ARC diagram help

Thank you.  I think this is what I need, but I am struggling with the Path Dimension and how to calculate or create it in my underlying data.  In the example you sent, it looks like it is a combination of Series ID and Series Sequence #.  My data has Week which is just a number 1-52, which I think would be the same as Series Sequence # here but then how do I get Series ID?  Do you have any ideas?

• ###### 4. Re: ARC diagram help

This is great and I was able to replicate what you did.  However, I added in some additional data, to compare against and the curves looked exactly the same for both sets of data when I expected them to be different.  Any ideas?

• ###### 5. Re: ARC diagram help

I'm not sure I follow. Could you include an example?

• ###### 6. Re: ARC diagram help

Sure.  I've added additional data for a 2nd year.  It is in the attached and winds up looking like this.

• ###### 7. Re: ARC diagram help

How do you expect them to look?

• ###### 8. Re: ARC diagram help

I imagined that when shown next to each other, they would look different from each other.  In the workbook, the sheet called EXAMPLE shows what I would have expected the top of each curve to be.  The value for week 4 in year 2017 is 120 where the value for week 4 in year 2018 is 135.

• ###### 9. Re: ARC diagram help

Are you encoding the height based on some measure in the data set? From the example and the calcs, it seemed to me that you were just trying to make them equidistant from each other.

• ###### 10. Re: ARC diagram help

Hoping to yes.  The data in the workbook shows that the values that I want to have the top of the arc represent.  So, if I show an arc that represents week 4, the top in 2017 would be 120 and in 2018 it would be 135.  I would expect the Y axis to represent the value (height of the arc), and the color of the arc to represent the week. • ###### 11. Re: ARC diagram help

So it looks like you're using the End At measure here, correct? If so, then change the Y (copy) calculated field to the following:

SIN([Point] * PI()/180) * [End At]

Then you should see the differences in height. To make it a little clearer, I added the ability to highlight a specific week via a parameter, which makes those arcs red and a bit thicker. Here it is with week 18 highlighted. Of course, you could also use a highlight action or something like that. I've attached the workbook.

Hope this works for you.

• ###### 12. Re: ARC diagram help

Thank you!!  This is exactly what I was looking for.  I appreciate all of your help!

• ###### 13. Re: ARC diagram help

Any time!

• ###### 14. Re: ARC diagram help

Is it possible to make an arc chart on a growing dataset?  The scenario is that we are making one off the server and using prep to union our data sources.

1 2 Previous Next