Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with the following data:
ID | Label1 | Label2 | Label3 | OpsDate |
ComA | 96% | 93% | 91% | 2023-05-31 |
ComB | 95% | 99% | 92% | 2023-05-31 |
ComC | 98% | 95% | 99% | 2023-05-31 |
ComA | 76% | 73% | 71% | 2023-04-30 |
ComB | 75% | 79% | 72% | 2023-04-30 |
ComC | 78% | 75% | 79% | 2023-04-30 |
Using the following code I created a line chart that shows the values for any one ID and one OpsDate at a time by using filters:
if(valuelist('Label1','Label2','Label3') = 'Label1',[Label1],
if(valuelist('Label1','Label2','Label3') = 'Label2',[Label2],
if(valuelist('Label1','Label2','Label3') = 'Label3',[Label3])))
It gives me the following output:
I have another table (unrelated to the data table) which contains the labels for each of these data points for each of the Ops date:
2023-04-30 | 2023-05-31 |
A | X |
B | Y |
C | X |
I want to be able to pick up the values from this table for the selected OpsDate in the filter and apply them as 'labels' in my chart shown above.
So for the OpsDate of 5-31-2023, the labels in the chart should show as 'X', 'Y' and 'Z' for the three data points.
Please help!
Excel data files attached.