5 Replies Latest reply on Dec 27, 2013 11:20 AM by Jonathan Whiting

# Annotations that change with parameters

Hello Tableau Community,

I'm trying to create an annotation that changes according to a parameter.

In the attached workbook, the annotation uses static text for the intrusion points, but it able to update the flow value when the parameter is chosen. Is there someway to make the updates automatic with calculated fields or something similar?

-Jonathan

• ###### 1. Re: Annotations that change with parameters

Sorry I'm confused. I opened your workbook. I changed the parameter and selected flow changed. What else were you hoping would happen? You want the Intrusion Point to change when the parameter is changed? In what way? So if the select flow is 51, what should the intrusion point change to? More importantly, what is the math to calc the change.

--Shawn

• ###### 2. Re: Annotations that change with parameters

Sorry, I should have explained this better. Changing the flow parameter will move the symbol along a line of best fit made for a larger dataset. Equations are as follows (Q = flow):

Mainstream: = -5.37978E6*Q^3 + 0.019355*Q^2 - 24.5677*Q + 7038.05

Ebey = -3.71063E6*Q^3 + 0.0220397*Q^2 - 38.3201*Q + 16854.5

Perhaps there would be an easier way to make the annotation change... by somehow applying these formulas directly in the annotation and based off the parameter?

• ###### 3. Re: Annotations that change with parameters

I think you're looking for a Point annotation:

--Shawn

1 of 1 people found this helpful
• ###### 4. Re: Annotations that change with parameters

Now I actually tried that before, but ran into two problems:

1. If I set the annotation to a point when the parameter is equal to 500, then it annotates until I change the parameter. If the parameter becomes 501, then the annotations disappear.
2. While I am only referencing two points in the sample, the full workbook is referencing four points. Creating four point annotations and getting the text to line up well is complicated at best. What makes matters worse is that the relative text size changes when moving between a sheet and a dashboard.

Do you have any recommendations for dealing this these problems?

• ###### 5. Re: Annotations that change with parameters

So any thoughts on what do do here? Or perhaps is there anywhere that I can provide more information?

Thanks,

-Jonathan