This content has been marked as final.
Show 3 replies

1. Re: if/then statements, sorting into categories
Tracy Rodgers Jul 3, 2013 1:07 PM (in response to Christy Rogers)Hi Christy,
Change the calculation to look similar to the following:
if sum([value])<=60 then 1
elseif sum([Value])>60 and sum([Value])<160 then 2
else 3
end
Then, you can add a window_sum to the calculation to find the total.
Hope this helps!
Tracy

2. Re: if/then statements, sorting into categories
Christy Rogers Jul 3, 2013 1:28 PM (in response to Tracy Rodgers)I put the code in calculation 1. Thank you!! I can see by the graph that it sorted the numbers correctly into 3 bins and graphed either a 1, 2, or 3. so then i should make a new calculation field to add those up?:
WINDOW_SUM([Calculation1] )

3. Re: if/then statements, sorting into categories
Christy Rogers Jul 5, 2013 8:02 AM (in response to Tracy Rodgers)can I use grand totals instead to get the total points (sum of all the 1s 2s and 3s?)