Could you please attach the data/workbook also.
You've to union the data sets then it will be very easy for your to plot the desire line graph.
Follow the above link for more detail on union.
Post union you have one addition field which will distinguish the data sets called Table name.
Now drag your date field on columns shelf and value on rows shelf
then put Table Name field on color.
Let us know if this help.
Thanks Meenu and Mahfooj. I have now attached the workbook.
Mahfooj, I tried your steps and I think I am still missing something. Appreciate if you can take a look.
Time question.twbx 10.6 KB
You were on right path, while union we need to keep few things in our mind fields names, data type and sequence of the fields among the sources should be identical. In your case, I've done some thing like this
I've renamed the fields and kept identical,
that was the most important part which you had missed. No worries
Once done with formatting of data structure I've saved the file and connected the source in tableau and union both the sources. You can see only one field you're getting for Date/time and Values earlier due to different field names union was not done properly.
Now go to worksheet and drag the fields like this
I hope this is what you wanted workbook as well as sample data in excel attached for your reference.
Yes this is what I need. I'll try applying this technique to my real data set.
Thanks a lot Mahfooj.
Glad I could help