This content has been marked as final.
Show 4 replies

1. Re: Using Averages to calculate confidence intervals and reference lines
Erin Slott Feb 26, 2018 7:56 AM (in response to Erin Slott)I have figured a way using my own calculated confidence intervals to use stacked area to shade the wanted band. I'd still like to know if there is a way to use Tableau's calculations? Again, I wouldn't want the reference line to be a whole average, but average of January 20152017 rates, then average of February 1517 rates, etc.

2. Re: Using Averages to calculate confidence intervals and reference lines
Yuriy Fal Feb 26, 2018 11:07 PM (in response to Erin Slott)1 of 1 people found this helpfulHi Erin,
If you make the Month pill on Columns a Discrete (Blue)
and choose to calculate Ref Lines per Cell, you may get it.
Yours,
Yuri

3. Re: Using Averages to calculate confidence intervals and reference lines
Erin Slott Feb 27, 2018 10:39 AM (in response to Yuriy Fal)Thank you. This solved that question. However, it looks like it's better if I calculate my own confidence intervals display wise. I can smooth out the shading better.

4. Re: Using Averages to calculate confidence intervals and reference lines
Yuriy Fal Feb 27, 2018 10:44 AM (in response to Erin Slott)As you wish :)