I have data that has multiple columns that contain timings for particular tasks on particular dates. I want to hide all but the last column when in a line chart. The sticking point is I want the line chart to still show the x-axis labels "process" names from the previous data collected, it just wouldn't connect the lines until that task is complete. This will allow the chart to show progression. I believe found the CSS method for doing this, but I'm not sure how to accomplish this in dashboard studio code.
Example:
Process | 08/24/2023 10:15:45 | 09/24/2023 11:15:44 | 10/24/2023 10:45:00 |
Task1 | 2.44 | 1.44 | 8.55 |
Task2 | 1.44 | 18.44 | 8.43 |
Task3 | 8.22 | 4.24 | |
Task4 | 4.44 | 8.12 |
The idea would be that the line chart would only show the last column in the list above, but still show all the process tasks on the x-axis. The example I created in paint below shows the X axis has the labels still, but the lines haven't been connected yet since those haven't completed yet.