Hi, I have thousands of lines of data across several months in the following format:
I want to produce a line graph which plots the percentage of result for each item for each month to track performance over time, preferably stacked to 100%. The graph does not have to track all items but if it could that would also be helpful. The total number of results does not remain constant with each month or each item.
I feel this should be a simple task, or something I could get from a pivot chart but I'm not finding anything elegant.
item | Date | Result |
A | 1/2/20 | Attention |
A | 1/24/20 | Attention |
B | 1/25/20 | Passed |
B | 1/24/20 | Passed |
B | 1/24/20 | Passed |
A | 1/24/20 | Failed |
A | 1/25/20 | Passed |
C | 1/25/20 | Passed |
C | 1/25/20 | Failed |
C | 1/25/20 | Passed |
I want to produce a line graph which plots the percentage of result for each item for each month to track performance over time, preferably stacked to 100%. The graph does not have to track all items but if it could that would also be helpful. The total number of results does not remain constant with each month or each item.
I feel this should be a simple task, or something I could get from a pivot chart but I'm not finding anything elegant.