PostGresSql to retrieve number of opened and closed tickets last month
Hello!
I need a report to show the following :
row : Number of requests opened
row : Number of requests closed
Column : Group by week : week 1, week 2 ...etc
The report should be ran for the data from previous month.
| w1 |
w2 |
w2 |
w4 |
|
| Number of opened request |
||||
| Number of closed request |
I have found similar queries but unfortunately are not for PostGres and my conversions aren't working!!
Servicedesk plus 9.4
Database : PostGreSQL