Free Data Visualization Software | Tableau Public



//Individuals Chart Signals Equation:

IF

Sum([Pass Yds])>(WINDOW_AVG(Sum([Pass Yds]))+3*(WINDOW_AVG([Moving Range]))/1.128)

THEN 'Outlier'

ELSEIF

Sum([Pass Yds])LOOKUP(Sum([Pass Yds]),-1) AND

LOOKUP(Sum([Pass Yds]),-1)>LOOKUP(Sum([Pass Yds]),-2) AND

LOOKUP(Sum([Pass Yds]),-2)>LOOKUP(Sum([Pass Yds]),-3) AND

LOOKUP(Sum([Pass Yds]),-3)>LOOKUP(Sum([Pass Yds]),-4) AND

LOOKUP(Sum([Pass Yds]),-4)>LOOKUP(Sum([Pass Yds]),-5) AND

LOOKUP(Sum([Pass Yds]),-5)>LOOKUP(Sum([Pass Yds]),-6)

THEN 'Trend'

ELSEIF

Sum([Pass Yds])WINDOW_AVG(Sum([Pass Yds])) AND

LOOKUP(Sum([Pass Yds]),-6)>WINDOW_AVG(Sum([Pass Yds])) AND

LOOKUP(Sum([Pass Yds]),-7)>WINDOW_AVG(Sum([Pass Yds])) AND

LOOKUP(Sum([Pass Yds]),-8)>WINDOW_AVG(Sum([Pass Yds]))

THEN 'Shift'

ELSEIF

Sum([Pass Yds]) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download