How to apply the legend only to the primary values in a 2-line line chart?

[Anonymous]

Here you can see I visualize a column with a legend, which works fine. But after this I need to put a column from a different table into this chart. The 2 tables don't have anything in common but the dates. I cannot put that field into the canvas if I don't get rid of the legend because the legend can't handle the other field. Is there a way to set the legend to only be applied to the primary values? 

Thank you in advance!!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can only have one column/measure in the value field when using legend field. You may consider to remove legend field and add multiple columns/measures to value field.

Best Regards,

Jay

[amitchandak]

@Anonymous , Not very clear. If you are using legend, you can not have 2 values/measure.

The way to use prod_level with other table, where it is not joined, is to populate one value on the key in new column and join with prod_level.