6 Replies Latest reply on Nov 10, 2016 11:32 PM by mortenbodaugaard.jrgensen

# Circle marks dependent on size

I have a data view where I'd like to have the icons (they are circles on a map, indicating change in time waited at the spot, so it can both be negative and positive) vary in size according to the value.

Now that is not a problem, I have just applied the variable to the size option in the marks card in tableau. BUT the issue is, that when I do this, values that are very negative become very small, and values that are very positive become very big. Most of the changes are around 0, so in reality i'd like the marks with a value close to 0 to be very small, and then either larger or smaller values get bigger according to the value.

So I think i'd really just like to change the "base" of the size calculation from being the smalles value (which is negative), to being 0.

Is it really not possible to do this, without scaling the variable? That is not really a great option, since it's chosen by a parameter, and i'd like to display the value in the tooltip too, but then i'd have to make some sort of parameter to choose tooltip too.

I hope you can help. Thanks!

• ###### 1. Re: Circle marks dependent on size

Hey Hans!

You can change the base size of the marks by selecting the dropdown on the legend for the size, and selecting 'Edit sizes...'. The size ranges can then be changed in Tableau Desktop for the marks:

• ###### 2. Re: Circle marks dependent on size

Here is one option that I can think off..... So basically what you want is show the circle size based on the absolute value rather than the actual values (which could be negative or positive).

Just to demonstrate the example, here is what I have done -

1. Calculate the 2014 and 2015 Sales separately.

2. Calculate the Sales growth between 2014 and 2015 sales - Sales Growth.

3. Create a calc that captures the absolute value of Sales Growth. This will be added on the size pill.

4. With step 3 calc, size of the bubble will be range fro 0 through absolute value. Now to identify whether the bubble size is positive or negative, I created another variable - Sales Growth Indicator -

5. I drop Sales Growth Indicator on the color to explicitly show whether the growth is +ve or -ve.

Here is the final result - I hilighted 2 of the states to show how they look like - Hope you can simulate the solution in your case as well.

1 of 1 people found this helpful
• ###### 3. Re: Circle marks dependent on size

Thanks a lot for the thorough explanation. I realize that it might be the way forward, but I was hoping that there was a way to just tell the size indicator that I wanted to calculate the size as the absolute value - but I guess that isn't possible.

• ###### 4. Re: Circle marks dependent on size

He is literally doing just that. Calculating the size as an absolute value and putting it on size.

• ###### 5. Re: Circle marks dependent on size

Yes, that is quite obvious, thank you. But as I wrote in my original question, what I really was looking for was a way to do it without having to calculate anything. That is, just tell the size marks card, that i wanted the size to be centered around 0 - so I could avoid having to calculate a new absolute value variable. I want to avoid that, because the variable is chosen in a parameter, and it means I have to do an extra calculation for the tooltip for the parameter too.

I know I can do that (now), but if tableau had given me a way to do it inherently in the programme it would certainly be easier.

• ###### 6. Re: Circle marks dependent on size

Well, to quote you

"..I wanted to calculate the size as the absolute value.."

You just want to be able to put it on a mark and right click and tick off a box like "Use absolute value" or something right? Personally I think that is a bad practice as it becomes less obvious what is happening in a viz if everything is hidden in formatting/manual settings on the marks. To each their own.