How to extarct more the two timestamps

[sdps963]

Hello everyone,

I've trouble pulling the data and your help needed.

I have a live dataset about a bank mobile application. It records customer name, customer Id and timestamps each time a customer logs into his application. I want to pull the data of the customers who have logged in more than two times in the last week.

Thanks in advance.

[Reeza]

How are you creating your query now?

If SQL, you can use HAVING. 

HAVING(count(customer_ID))>1 

[sdps963]

Awesome, Thank you

[Reeza]

Sorry, that won't factor in last week, you'll have to also include a date filter. I'll leave that up to you because we can't see how your query is working.