This is kind of stupid approach, but only reasonable way I know of.
Duplicate data with union.
Add couple of calculated fields.
Filtering data able - Sheet1
Filtering data able - Sheet11
User always need to check " Always Show" to keep another table color.
dual Axis -2_SM_10.4.twbx 70.4 KB
how did you duplicate the data? I did not quite understand the first step. How did sheet 11 came in? Did you rename it? Or how did you duplicate sheet 1?
Drag same sheet twice.
Tableau automatically add unique name with extra numbers.
Thanks @shinichiro , oh it was first taking it as sheet 1. therefore got confused..... But the REAL DATA that I have is coming in from MySQL.. how do I duplicate and do a union on that???
Would this different approach work?
if [last login] = "12/01/2017" OR "13/01/2017" OR "14/01/2017" etc etc THEN 1 else 0 END
Then place this on one of the marks cards in a dual axis so it only paints up only these points, where the other marks card will have the remainder.
I tried this too, but its not working quite right, can you help modify?