Hello, as the title says I am trying to figure out a beast mode or add an additional column in a view/etl to flag a member when they logged in fewer times this current month compared to the previous month. I manually upload the month's numbers at the end of the month so we are measuring trends and wanting to reach out to members that stopped logging in as much.
Here is what my data should look like:
Member | Login Date | Login Value | |
---|
Banana | 12/1/23 | 6 | |
Banana | 1/1/24 | 10 | 66% Increase |
Pear | 8/1/23 | 4 | |
Pear | 12/1/23 | 10 | |
Pear | 1/1/24 | 2 | 80% decrease |
Lemon | 12/1/23 | 9 | |
Lemon | 1/1/24 | 10 | 11% Increase |
Lemon | 7/1/23 | 6 | |
Kiwi | 2/1/23 | 0 | |
I want it to grab just the previous month to calculate the percent in change but also highlight any that show a decrease. I think I would like to make a metric card that shows like "7 decreases this month" and have it drill down to a table of those decreases for reference.
Thanks in advance!