Hi everyone! This feels like something that already exists that I just can't seem to find - we want to see the number of donors who are repeat donors, specifically looking year to year.
IE. number of 2023 donors who gave in 2022; number of 2023 donors who gave in 2022 AND 2021; number of 2023 donors who gave in 2022 AND 2021 AND 2020; and so on and so forth
I'm a little familiar with the bucketing technique, but it doesn't seem to want to cooperate in the Contributions cube. Way down the line it would be cool to find out who those people are, but for the time being we're just looking at numbers.
Thoughts?
I am running this code
CASE WHEN MIN([Campaign Fiscal Year] ) = 2018 THEN COUNT( [Constituent ID] , (MAX([Constituent ID]) , [Fiscal Year1 = 2017] ) )WHEN MIN([Campaign Fiscal Year] ) = 2019 THEN COUNT( [Constituent ID] , (MAX([Constituent ID]) , [Fiscal Year2 = 2018] ) )WHEN MIN([Campaign Fiscal Year] ) = 2020 THEN COUNT( [Constituent ID] , (MAX([Constituent ID]), [Fiscal Year3 = 2019] ) )WHEN MIN([Campaign Fiscal Year] ) = 2021 THEN COUNT( [Constituent ID] , (MAX([Constituent ID]) , [Fiscal Year4 =2020] ) )WHEN MIN([Campaign Fiscal Year] ) = 2022 THEN COUNT( [Constituent ID] , (MAX([Constituent ID]), [Fiscal Year5 =2021] ) )WHEN MIN([Campaign Fiscal Year] ) = 2023 THEN COUNT( [Constituent ID] , (MAX([Constituent ID]) , [Fiscal Year6 =2022] ) )ELSE 0 END
When I try to drill into the data in the column for #Renewed from last year it pops a window that shows a filter with Fiscal Year1 = 2017 regardless of the row of data that I have selected. I would show a screen shot but can't paste an image in this window for some reason.
What have I done wrong?