2017 Nov 19 1:21 PM
Hi everyone, I need help with using the SQL Filter Expression IN SAP HANA. The main goal is to count the number of transactions within the last 24 hours. I was able to join 2 transaction tables but I got stuck in the projection level (Filter). It is giving me an error when I enter the 43200 seconds as a criteria. Can you help me figure out what is wrong?
Hi everyone, I need help with using the SQL Filter Expression IN SAP HANA. The main goal is to count the number of transactions within the last 24 hours. I was able to join 2 transaction tables but I got stuck in the projection level (Filter). It is giving me an error when I enter the 43200 seconds as a criteria. Can you help me figure out what is wrong?
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |