Hi,
I am trying to build a report and I struggle with counting the work orders on a month by month basis in a single Table Visualisation because each type of work has a different month column depending on it's status and source of work.
The result I want to achieve is below.
Data source:
How could I do this in a single table visualisation?
Thank you
I am trying to build a report and I struggle with counting the work orders on a month by month basis in a single Table Visualisation because each type of work has a different month column depending on it's status and source of work.
The result I want to achieve is below.
January | February | March | April | May | June | July | |
Programme Works (Source of Work = Programme , PROGRAMME Planned Month for completion) | 6 | ||||||
Programme Works Adhoc (Source of Work = Programme Adhoc , Planned Month for completion) | 1 | ||||||
Completed Programme Works (Source of Work = Programme Adhoc + Programme , Status = Completed, Actual Completion Date) | 1 | 1 | |||||
Forecast Works (Status = Scheduled, Planned Month for completion) | 4 | 2 |
Data source:
Source of Work | PROGRAMME Planned month for work to start | PROGRAMME Planned Month for completion | Planned month for work to start | Planned Month for completion | Status of Proposed work | Actual Start Date | Actual Completion Date |
Programme | March | March | April | April | Scheduled | ||
Programme | March | March | March | March | Scheduled | ||
Programme | March | March | March | March | Scheduled | ||
Programme | March | March | April | April | Scheduled | ||
Programme | March | March | March | March | Scheduled | ||
Programme | March | March | March | March | Completed | 01/03/2021 | 15/03/2021 |
Programme Adhoc | February | February | Completed | 15/02/2021 | 18/02/2021 | ||
Adhoc | February | February | Completed | 25/02/2021 | 26/02/2021 | ||
Adhoc | February | Mar | Completed | 16/03/2021 | 16/03/2021 | ||
Adhoc | February | Mar | Completed | 15/03/2021 | 15/03/2021 | ||
Adhoc | February | February | Completed | 16/02/2021 | 19/02/2021 |
How could I do this in a single table visualisation?
Thank you