-
1. Re: How to identify members year over year across 3 years?
meenu choudhary Oct 9, 2018 8:00 AM (in response to Tony Fahd) -
2. Re: How to identify members year over year across 3 years?
Tony Fahd Oct 9, 2018 8:39 AM (in response to meenu choudhary)yes this is great. what about if i want to add 3 other occurrences: one would be members in 2016 and 2017, members in 2017 and 2018 and members in 2016 and 2018
-
3. Re: How to identify members year over year across 3 years?
Kelly McGrady Oct 9, 2018 8:46 AM (in response to Tony Fahd)ELSEIF [Year] = "2016" AND [Year] = "2017" THEN "Two Years" something to that effect
-
4. Re: How to identify members year over year across 3 years?
meenu choudhary Oct 9, 2018 8:55 AM (in response to Tony Fahd) -
5. Re: How to identify members year over year across 3 years?
Tony Fahd Oct 9, 2018 10:05 AM (in response to meenu choudhary)Thanks Meenu! one last question, anyway i can separate the Two years into 3 buckets(2016 and 2017),(2016 and 2018) and (2017 and 2018).
Thanks for the help, this is great
-
6. Re: How to identify members year over year across 3 years?
meenu choudhary Oct 9, 2018 8:26 PM (in response to Tony Fahd)Hi Tony,
If your query is resolved, please mark the answer as CORRECT and HELPFUL, so as to close the thread.
-
7. Re: How to identify members year over year across 3 years?
Tony Fahd Oct 10, 2018 10:30 AM (in response to meenu choudhary)Thanks Meenu! one last question, anyway i can separate the Two years into 3 buckets(2016 and 2017),(2016 and 2018) and (2017 and 2018).
Thanks for the help, this is great
-
8. Re: How to identify members year over year across 3 years?
meenu choudhary Oct 11, 2018 4:45 AM (in response to Tony Fahd)1 of 1 people found this helpfulHello Tony,
You can tweak the logic as shown below:
occurrence =
if [Year Occurrence per customer]=1 then "Only "+[Year]
elseif [Year Occurrence per customer]=3 then "All three Years"
elseif [Year Occurrence per customer]=2 then
{FIXED [Customer]:MAX([Year])} +' and ' + {FIXED [Customer]:MIN([Year])}
END
-
9. Re: How to identify members year over year across 3 years?
Tony Fahd Oct 11, 2018 10:05 AM (in response to meenu choudhary)Meenu, this is works great. Thanks!!
Tony