1 2 Previous Next 23 Replies Latest reply on Jan 16, 2019 4:50 AM by Leanne Vermeulen

# Setting Fixed Max Value of Radial Charts

Hey guys, perhaps my mathematical mind is just failing me today, but does anyone know how to adjust Toan Hoang's Radial Chart to always be set to a maximum of 10? Tableau Tutorial: Radial Bar Chart

I have a dataset that contains scores that will never be more than the value "10". So what I want is a radial chart that measures multiple scores out of 10; so it would look something like this:

The current method uses the value of 270 to set the maximum value in the dataset to take up three quarters of a whole circle. I don't want this relativity; I need an absolute radius of 360 set to a value of 10.

I've tried modifying the path value, setting values to 10 for those; I've tried manually setting the MAX calculations, as well as a few other things - no luck.

Any ideas how to achieve this?

Thanks, guys!

• ###### 1. Re: Setting Fixed Max Value of Radial Charts

Leanne,

I'm not sure if this quite got there,but I created a scaled field of [Path360]:

[Path]*360/270

And then Replaced References of [Path] to [Path360].

2 of 2 people found this helpful
• ###### 2. Re: Setting Fixed Max Value of Radial Charts

Definitely a lot closer! I tweaked the values a bit to get the proportions right, but when I apply filters it creates issues

• ###### 3. Re: Setting Fixed Max Value of Radial Charts

hi Leanne,

So building on Swaroop's amendment I also altered the Max Value to this...

That seems to do the job, but let me know if not

1 of 1 people found this helpful
• ###### 4. Re: Setting Fixed Max Value of Radial Charts

Aah, yes that makes sense! Only issue is that the scaling calculation won't work on the actual work file I'm working on - it completely distorts the graph so that only half of it shows. Unfortunately I can't share the work file itself because of the data it contains but the structure is exactly the same. So I'm gonna need to play around with it some more, I guess. But thanks to you both! This has helped move me forward a bit.

• ###### 5. Re: Setting Fixed Max Value of Radial Charts

hmmm ...very strange. One thing to check would be the Table Calculation Set up (addressing/partitioning) for X & Y. They need to be set up exactly as per the example you posted (both in what is ticked at each level, and the order that they appear, where each nested Table Calculation needs to be set up differently)

• ###### 6. Re: Setting Fixed Max Value of Radial Charts

Hey Simon Runc, yeah it's definitely not that - checked it a few times.

However, I managed to create a version of the file with dummy data, so you could take a look if you don't mind - file attached.

The first graph is doing exactly what I was referring to above. The second won't even calculate a radial chart at all now with the Path360 calculation in place (no 'Max' changes for this yet).

• ###### 7. Re: Setting Fixed Max Value of Radial Charts

hi Leanne,

So on the second chart the problem is that the data (using the bin pill) isn't densified, so Tableau isn't creating all the points between 1 and 360 that it needs to draw a nice circle.

Oddly you can only set this when on a column/row. So drag the path (bin) onto the column/row shelf, select "show missing values" and then put it back on path.

I'm getting some very odd (although quite hypnotic!) shapes, so I'll need to have a bit of a deeper look tomorrow.

• ###### 8. Re: Setting Fixed Max Value of Radial Charts

Aah, interesting! Ok cool, 1 down - 1 to go!

• ###### 9. Re: Setting Fixed Max Value of Radial Charts

hi Leanne,

So I've had a quick look at the first chart, and I think the problem is that your Values don't go between 0-10. They go much much bigger than that, and this is why you got such a Spirograph-y shape (if you remember that toy from back in the day!) ..the lines is going round many many times!

By setting the Max Value back to being the actual Max Value, I now get a full circle

The problem is that the scales of your metrics are so different. Which is why the largest metric (Energy Performance Score, in the 100s of Millions) goes right round and the others barely register. I think you need to "normalise" the numbers so they are on the same scale. I don't know the data or the problem, but I've added in a Value Normalised as an example of how to re-scale them between 0 and 10 (this just looks for the selected value in reference to all values for that metric)

• ###### 10. Re: Setting Fixed Max Value of Radial Charts

Thanks Simon - but that's really odd though? I double checked the data and the max value in the dataset is definitely only 7.4?

• ###### 11. Re: Setting Fixed Max Value of Radial Charts

I’m off for the next few days, but I’ll have a double check when I get back

...might well have been too hasty in my assessment!!

On Fri, 7 Dec 2018 at 20:33, Leanne Vermeulen <tableaucommunity@tableau.com>

• ###### 12. Re: Setting Fixed Max Value of Radial Charts

hi Leanne,

So looking at the data for the Radial Data, filtered down to a single Building/Date, as per your workbook (in the dummy.twbx file I have) ...

and for the other data source

I can't find any other "value" fields. Which one should I be looking at?

• ###### 13. Re: Setting Fixed Max Value of Radial Charts

Odd.. the raw data file I used for that definitely doesn't have those figures. Let me have a look at what's happening with the import tonight and get back to you. Sorry about this!

• ###### 14. Re: Setting Fixed Max Value of Radial Charts

Am I losing my mind and missing something obvious?

1 2 Previous Next