I am kind of new to Jasper Reports, so please bear this in mind.
So I have a query, where I get the following results:
| created | lu | wqu |
|----------|----------|----------|
| 2024-06-18 13:40:02.0818+0200 | ID | 80 |
| 2024-06-18 13:42:02.0818+0200 | ID | 60 |
| 2024-06-18 15:40:02.0818+0200 | ID | 37 |
| 2024-06-18 18:23:02.0818+0200 | ID | 20 |
What I want to achieve is the following (see table below):
- group by 15 or 60 minutes (created column value should be watched for it)
- count the values for WQU column with all those come together into the same group
Maybe I am overthinking it, but I do not know how could I do with Jasper Studio. Maybe there is a hidden helper for it?
| date | No. of lu | wqu |
|----------|----------|----------|
| 2024-06-18 13:00 - 14:00 | 2 pieces | 150 |
| 2024-06-18 14:00 - 15:00 | 0 piece | 0 |
| 2024-06-18 15:00 - 16:00 | 1 piece | 37 |
| 2024-06-18 16:00 - 17:00 | 0 piece | 0 |
| 2024-06-18 17:00 - 18:00 | 0 piece | 0 |
| 2024-06-18 18:00 - 19:00 | 1 pieces | 20 |