Name your DataSpace and select the NFL data sets for this tutorial. 
The concepts in this guide can also be used for NHL, NBA and MLB. As well as Yahoo Fantasy teams.

Select the following fields from the Player Stats data set:

Name
Team
REC
Rush YDS
Rec YDS
Rush ATT
Pass YDS
COMP

Click "NEXT", then "CREATE DATASPACE".

Custom Calculated Column - Fantasy League Points

Custom Calculated Columns can be added by clicking "ADD NEW COLUMN"

Enter a name for your Custom Calculated Column

Function arguments must be within square brackets.
ex: sum([goals, assists])

Click the Expression field to enter your formula

For this example we'll use the following formula, which is designed to calculate Fantasy Points for a Fantasy League. This formula can be modified to match your league's scoring system:

(Player_Stats__regular_season_passing_touchdowns*4)+
(Player_Stats__regular_season_passing_interceptions*-1)+
(Player_Stats__regular_season_passing_yards/25)+
(Player_Stats__regular_season_rushing_touchdowns*6)+
(Player_Stats__regular_season_rushing_yards/10)+
(Player_Stats__regular_season_receptions*0.5)+
(Player_Stats__regular_season_receiving_yards/10)+
(Player_Stats__regular_season_receiving_touchdowns*6)+
((Player_Stats__regular_season_punt_return_touchdowns+
Player_Stats__regular_season_kick_return_touchdowns)*6)+
((Player_Stats__regular_season_two_point_conversion_pass_completions+
Player_Stats__regular_season_two_point_conversion_reception_succeeded+
Player_Stats__regular_season_two_point_conversion_rush_succeeded)*2)+
(Player_Stats__regular_season_fumbles_lost*-2)

Your Custom Calculated Column can be sorted and filtered like any other column in SportWise.

Tip! SportWise supports multiple calculated columns.  And the calculated values can be referenced in other Custom Calculated Columns - they'll be listed with the name you provided (ex: Custom Fantasy Points).

Rolling-Insights

SportWise provides the power of a spreadsheet with daily stats updates for NFL, NBA, MLB and NHL.  When configured, stats from your Yahoo Fantasy League will also be updated daily.

Custom Calculated Columns can be used in any DataSpace.  



SportWise - Custom Calculated Columns

DataSpace Creation

Custom Calculated Column - Fantasy League Points

Calculation Formula