finding rows that got recorded within a time period

Hey there. I want to find the rows (names) who got recorded more than once in a period of month. This means that I want to get the count of people who got more than 1 ticket (in 30 days period).

I also want to find which month was most profitable in terms of amount.

test.xlsx

Transformation

Preparation

Accepted answers

binu_acs

@Dennis229 One way of doing this

Recorded_TimePeriod_011523.yxzp

All comments

ShankerV

Hi @Dennis229

Please find the expected solution.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!