Hi,
After I convert the sql script below to qlick sense script, I want to find customers who made 10 and more transaction in 1 hour. For example, if the customer made 10 or more transactions between 13:44 - 14:44 I want to find that customer. I would be glad if you can help about it. related sql querry is below.
best regards,
Load *,
MKY_MUS_MBB_NO,
HIS_ORD_KAYIT_TARIH ,
HIS_ORD_KAYIT_ZAM ,
Text(Time((HIS_ORD_KAYIT_ZAMANI+(1/24)), 'hh:mm:ss'))as onetime,
DATE(HIS_ORD_KAYIT_TARIHI, 'DD.MM.YYYY') AS KAYIT_TARIHI
;
