Hi Hopefully someone can help! I would like to display the following data as a chart, however the chart is only showing the time and not the date. I would also like the chart to have the percentage level and pump status displayed.
Date | Time | Bore Hole Pump Status | Bore Hole Pump Status % | Lake Level % |
01/06/2022 | 12:00:00 | on | 100 | 65 |
01/06/2022 | 13:00:00 | on | 100 | 66 |
01/06/2022 | 14:00:00 | on | 100 | 62 |
01/06/2022 | 15:00:00 | on | 100 | 67 |
01/06/2022 | 16:00:00 | on | 100 | 63 |
01/06/2022 | 17:00:00 | on | 100 | 61 |
01/06/2022 | 18:00:00 | on | 100 | 60 |
01/06/2022 | 19:00:00 | on | 100 | 64 |
01/06/2022 | 20:00:00 | on | 100 | 65 |
01/06/2022 | 21:00:00 | on | 100 | 63 |
01/06/2022 | 22:00:00 | on | 100 | 65 |
01/06/2022 | 23:00:00 | on | 100 | 63 |
02/06/2022 | 00:00:00 | off | 50 | 55 |
02/06/2022 | 01:00:00 | off | 50 | 55 |
02/06/2022 | 02:00:00 | off | 50 | 55 |
02/06/2022 | 03:00:00 | off | 50 | 55 |
02/06/2022 | 04:00:00 | off | 50 | 55 |
02/06/2022 | 05:00:00 | off | 50 | 55 |
02/06/2022 | 06:00:00 | off | 50 | 55 |
02/06/2022 | 07:00:00 | on | 100 | 65 |
02/06/2022 | 08:00:00 | on | 100 | 66 |
02/06/2022 | 09:00:00 | on | 100 | 62 |
02/06/2022 | 10:00:00 | on | 100 | 67 |
02/06/2022 | 11:00:00 | on | 100 | 63 |
02/06/2022 | 12:00:00 | on | 100 | 61 |
02/06/2022 | 13:00:00 | on | 100 | 60 |
02/06/2022 | 14:00:00 | on | 100 | 64 |
02/06/2022 | 15:00:00 | on | 100 | 65 |
02/06/2022 | 16:00:00 | on | 100 | 63 |
02/06/2022 | 17:00:00 | on | 100 | 65 |
02/06/2022 | 18:00:00 | on | 100 | 63 |
02/06/2022 | 19:00:00 | on | 100 | 63 |
02/06/2022 | 20:00:00 | on | 100 | 63 |