4 Replies Latest reply on Mar 24, 2016 6:03 AM by Stephen Crocker

# Need help with How to analyize this

I have a need to find out the number of people that have been new players in a golf tournament  for each year from 2013 forward to current.  I have the new players for 2016 figured out which was pretty easy with a simple calculation but the others I'm not sure.

I have included a book if someone would like to help out with this.  I need it pretty quickly and am frustrated with how to get the information.

Here is what I need

I need to know the players in 2013 that were new.  This would be looking across the data and finding where the first 1 is in 2013.  Then I need to know if those that were in 2013 and were new players if they played in 2014, then the same thing for 14, 15 and 16.

I used the following calculated field to see 2016 and it worked.

If [TotalyrsGolfReg] = 1 and [GOLF2016]=1 then 1 else 0 end   then just filtered it out.

So I think I need to do calculated fields but unsure what to do.

Thanks

• ###### 1. Re: Need help with How to analyize this

I would amend the view definition that you connect to so that you have one field with the year instead those 20 columns for each. Whatever you do with this view will only work this year and you're gonna add new columns for future years I guess.

• ###### 2. Re: Need help with How to analyize this

I have the data in a different format now, again I'm able to get the furthest out (2016) event with the correct number of people that were new.  I don't know how to find out the new people in 2015 and if they were retained in 2016 and back to 14, 13.  I don't need to go any further then 13

• ###### 3. Re: Need help with How to analyize this

OK

attached are 2 solutions: based on table calculations (TC) and on LoD expressions

you can choose which one suits you best - LoD I guess

I put on Grand Totals but they show different results as it is rather tricky as to what they should show - maybe you do not need them anyway...

As to the 2013 - it is selected with the parameter titled "The Event" so you have a more general solution

cheers

1 of 1 people found this helpful
• ###### 4. Re: Need help with How to analyize this

Thank you very much for this.  It's exactly what I needed.  I had to tweak a couple of things and add some data blending but it worked like a champ.  Awesome.  Thank you again.