Welcome to the Forum.
I may not have caught the gist, but I think there may be a few ways
to get the line chart with test vs. control. I'll show a couple, maybe
they can give ideas.
You could make a Test or Control calculated field:
IF [Test]=1 THEN "Test"
ELSEIF [Control]=1 THEN "Control"
You could then plot date vs. sales and put the [Test or Control]
field on the Color shelf.
Another method is to pivot your data which can be done in Prep or by:
Then no calculated field is needed, just Pivot Field Name
(which will be Test or Control) on the color shelf, and
Pivot Field Value (which is one or zero) on the Filter shelf
selecting for 1.
These may be overly simplistic for your true dataset and setup.
Happy to try to adjust as needed.
Please see the workbook v10.3 attached in the Forum Thread.
279499control.twbx 16.0 KB