SQL count of vacant positions in each department for the last three months
Summarycount of vacant positions for each department group by the last three months
I am trying to write a sql in BIP to get the count of active vacant positions for each department and further group them by the last 3 months when run as of the sysdate. It needs to be a BIP and not OTBI. If you have achieved this before then could you please share the SQL code? It would be a pivot table with details such as below.
|Number of Vacant Position
Many thanks in advance,