I could do this. Kindly check the screenshots and attached. Second Screenshot is from your file and the first is created by me. So, I took all your data source, Created csv files and used UNION to create one dataset. Book1, Book2 and Book3 are three csv files which I combined. In the attached, you would find that since my Tableau is in English, so I got the Dimension names Changed, but it worked.
Hope it Helps!!!
Let me know.
Combined graph.twbx 99.0 KB
thanks for spending some time helping me!
I can't open your file, I get this error
I didn't know about union, thanks for the info.
If I got it right from this Union Your Data, Union will merge all my data in one file which I don't get how it will help me.
Anyway, I tried using it merging my data but I think what it created was a mess until i noticed the "table name" under "Marks" field. And then I got it working!!!!
For future reference, I should declare that you have to use the dimension "table name" and drag it on the color mark. You could use it as a filter as well.
thank you so much for your help!