finding rows that got recorded within a time period

[Dennis229]

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. 

[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!!!!

Many thanks

Shanker V

[RobertOdera]

Hi, @Dennis229 

It seems you left a lot open for interpretation.

What I gathered is:

1. What is the count of people who received multiple tickets within 30 days of a previous ticket

2. What was the month, irrespective of year, that had the highest total fine amount

Please mark this as an acceptable solution if it works for you.

Cheers!

[binuacs · Accepted solution]

@Dennis229 One way of doing this