Is there a way to create a stacked column chart where the X axis is the column headers and the Y axis is the count of No's in the corresponding column? id like to add a slicer to filter by date but building the bones of the chart is my first hurdle.
every time i add more measures to the X axis is doesn't display it.
thank you for your help
| ID | Start time | end time | email | Which checks are you completing? | are there any open documents? | Checking 3 personnel in work today, are all of their Mandatory competencies in date? | Checking 5 personnel, in total, across shift and support, have they had their appraisal completed? | documentation to be checked for accuracy. Are both compliant? | Have duty crews been assigned for this week and the following week? | Has the Mandatory Training board been updated during the previous month? | Is the notice boards in the T-Bar up to date? | Is the Social notice board in the T-Bar up to date? |
| 47 | 16/11/2022 07:27 | 16/11/2022 07:27 | anonymous | Personnel weekly | No | Yes | Yes | No | Yes | Yes | Yes | Yes |
| 47 | 17/11/2022 20:06 | 17/11/2022 20:06 | anonymous | Personnel weekly | No | Yes | Yes | No | No | N/A | No | No |
| 48 | 23/11/2022 12:04 | 23/11/2022 12:04 | anonymous | Personnel weekly | No | Yes | Yes | yes | Yes | N/A | Yes | Yes |
| 49 | 01/12/2022 21:35 | 01/12/2022 21:35 | anonymous | Personnel weekly | No | No | Yes | No | No | N/A | No | No |
| 50 | 06/12/2022 07:58 | 06/12/2022 07:58 | anonymous | Personnel weekly | No | No | Yes | Yes | Yes | No | Yes | Yes |
| 51 | 12/12/2022 15:00 | 12/12/2022 15:00 | anonymous | Personnel weekly | No | Yes | Yes | Yes | Yes | N/A | Yes | Yes |
| 2 | 11/01/2023 13:36 | 11/01/2023 13:36 | anonymous | Personnel weekly | no | No | Yes | yes | Yes | Yes | Yes | Yes |
| 3 | 18/01/2023 10:40 | 18/01/2023 10:40 | anonymous | Personnel weekly | No | Yes | Yes | Yes | Yes | N/A | Yes | Yes |
