6 Replies Latest reply on Aug 20, 2015 12:58 AM by Damien Flood

# Reference Bands - based on y axis e.g. 1-100%

Dear all,

Working in Tableau Public I am experimenting with adding reference bands to my chart.

Values(%) over time (Year) but want the bands to highlight values in the following sections

0-64% (Red)

65-79% (Orange)

80-100% (Green)

I'm finding it hard display this on the chart as the data will not be a minimum of 0 and max of 100.

Hope this makes sense...and any help would be great.

Cheers

• ###### 1. Re: Reference Bands - based on y axis e.g. 1-100%

Hi Damien,

Could you attach your workbook or add some sample workbook to explain the problem you're having?

In your screenshot it looks like everything is fine, despite there not being a 0 minimum (though potentially the bands are not exactly at the numbers you mentioned)

• ###### 2. Re: Reference Bands - based on y axis e.g. 1-100%

Hi Dana,

Please find attached workbook as an example.

Cheers

• ###### 3. Re: Reference Bands - based on y axis e.g. 1-100%

Hi Damien,

Thanks for the workbook - I see what you mean now.

I found an easy cheat instead of using your reference bands as percentage of maximum, I've created a parameter and set it to 1 (for 100%) and made the bands follow 64,80 percent of that parameter. See workbook attached.

Hope that helps,

Dana

• ###### 4. Re: Reference Bands - based on y axis e.g. 1-100%

Thanks Dana,

Wondering is it possible to explain the creating and applying the parameter as I am not able to open the workbook. I am use tableau public.

Cheers

• ###### 5. Re: Reference Bands - based on y axis e.g. 1-100%

Hi Damien,

Sorry I should have thought about that...

For the first graph I did the following:

1. I went to edit reference line and in the dropdown for the value chose: Create a new Parameter (you can also do this separately of course).

2. I've created a "100 Percent" parameter with a value of 1 (100%)

3. Once I have that in the reference setup I've chosen to use that parameter with the aggregation of average (the value should be 100% at each level and not add up or anything). And I've set the percentages to what you described.

Because on average that parameter is always going to be 100%, it does not matter anymore that your data is not:

For every following graph I can now set up the same, only I do not have to create this parameter anymore as it is already there. Just follow step 3 for each of your other graphs.

Hope that helps!

Dana

• ###### 6. Re: Reference Bands - based on y axis e.g. 1-100%

Thanks so much Dana...this is great