This content has been marked as final.
Show 2 replies

1. Re: Reference Line base on a calculation
Dimitri.B Apr 4, 2012 8:09 PM (in response to Allison Suarez)You were on the right track, but the problem is that in this case both average and stdev are properties of the whole sample, while Tableau automatically uses only what is inside a cell for calculations. If your imagine a table behind your graph, then your forumlae will calculate AVG and STDEV for each cell of the table, not the whole table; but you need the whole table.
In other words, you should have used table calculations for average and St.Dev, i.e.
WINDOW_AVG(...) and WINDOW_STDEV(...)
See attached workbook for the solution (I had to remove the filter to match the numbers in your post).

2. Re: Reference Line base on a calculation
Allison Suarez Apr 6, 2012 9:53 AM (in response to Dimitri.B)Worked like a charm . . . but i'm sure you knew that. Thanks so much!