A simplified version of data I'm working with for example purposes:
| Identifier | Data1 | Stage | Completed? |
| Active1 | 2 | 1 | |
| Active1 | 4 | 2 | |
| Active2 | 4 | 1 | |
| Active2 | 3 | 2 | |
| Active3 | 5 | 1 | |
| Active3 | 4 | 2 | |
| Completed1 | 6 | 1 | 4/15/2019 |
| Completed1 | 7 | 2 | 4/15/2019 |
| Completed2 | 4 | 1 | 4/12/2019 |
| Completed2 | 2 | 2 | 4/12/2019 |
| Completed3 | 8 | 1 | 3/28/2019 |
| Completed3 | 6 | 2 | 3/28/2019 |
| Completed4 | 8 | 1 | 2/15/2019 |
| Completed4 | 2 | 2 | 2/15/2019 |
Stage would be along the X-Axis (so only 1 and 2 for this example). I would have 4 lines.
Active 1: 2 , 4
Active 2: 4 , 3
Active 3: 5 , 4
CompositeCompleted: 6.5 , 4.25 (average of all Completed for each stage)
Basically, I'm trying to plot all active data as individual lines, and then all completed data as one line. I have the data plotting correctly independent of each other. I have created 2 measures - one called Active and the other called Composite. Composite takes the avg(Data1) and filters where Completed? is not blank. Active looks where Completed? is blank. If I put Composite as a Value and do not include anything in my Legend - it graphs fine. If I put Active in my Values and include Identifier in the Legend, it plots all 3 lines. I don't know how to plot one composite line and also the 3 non-composite lines at the same time. I can't seem to figure it out. I really tried to simplify what I'm doing for help - but if you need more details please let me know and I can post some. But essentially I think the main issue is how do I have a legend of the different Identifiers and then a custom one called Composite (instead of completed1, completed2, etc.)
