Forum Discussion
Insert a graph line based on a condition
I have a question regarding a line graph. I have a data sheet which has a list of applicants for different events. Which looks something like this:
| ID | Registration date | Event |
| 1112 | 1-3-2023 | T16 |
| 1111 | 2-4-2023 | T13 |
| 1110 | 11-3-2023 | T14 |
| 1109 | 18-4-2023 | T14 |
| 1108 | 25-3-2023 | T14 |
| 1107 | 20-3-2023 | T17 |
| 1106 | 5-4-2023 | T16 |
| 1105 | 7-3-2023 | T15 |
| 1104 | 16-4-2023 | T14 |
| 1103 | 21-3-2023 | T13 |
I want to create a graph where I see the application progress overtime (which can be done easily by adding the date column to the X-axis and the ID column to the Y-axis). But besides that I want to add a second line for each event. (So one graph which has the overall line and a line for T13, one graph with T14, etc.) How do I do this?
1 Reply
Anonymous , You can use the event in the legend
If not you have create measures to do that
