Good morning - the red pill usually means that the field is broken in some way - look at Measures under Data and see if any on the measures have a red ! - that would give you a path to see what is broken
What Jim said and....
Also check any calculations you have in the workbook.
If you created groups, you may need to update the groups. I'm not sure why, but groups don't seem to upgrade like everything else.
What is interesting is that it is the "shapes" pill that turned red, so I'm guessing you have a group or calculation that is used to assign shapes somewhere.@
I realize red means broken but everything seems to be in order. I don't have any red ! marks in my measures pane and furthermore all the pills on the individual layer marks cards are all green or blue not red. So not sure why this multiple fields on my "All" marks card layer is red.
The red pill plunges you into the real world.
The first thing I would try is to look at all the individual MARKS layers. But you said you did that already. (And the sheet works, even with the red pill in there?)
The next thing I would try is "Duplicate Sheet". Does the red pill go away on the copy?
If not, the next thing I would try is to delete individual measures from the rows/columns shelf. One at a time. Hit back-arrow after each one to put it back on. Or combos of deletions. Or delete them all and then back-arrow to put them back on...
Just some ideas. Those are things I would try.
You might have a bug to report once you get this thing sorted out.
BTW, if you want me to try it for you, I could take your 9.2 workbook and upgrade it to 9.3. And then to 10.0. And then to 10.1. I have all the intervening desktop versions available to me. Let me know if you want that. It might be interesting to see what happens.
Thanks Joe those are great thoughts. I tried all of those things and still the red persists on the multiple fields pill. What is even funnier is that only 2 of the 4 marks layers are using shapes and when I remove shapes from one of those 2 layers the shapes multiple fields pill persists. Even when I remove all of them and just add one back in I get the multiple fields (red) pill on the "All" marks card. Very strange. I also looked at the describe sheets detail and nothing stands out there.
This is a long shot but have you tried re-selecting the shapes? Maybe there is a particular shape that your pill is using that changed between the two versions.
Christina, That's another good thought that I just tried but it still doesn't resolve it. When I force the other multiple field pills to go red they give me a tooltip stating invalid and along with marks card layer. I get no tooltip for the seemingly corrupt one.
btw speaking of tooltips I really was delighted about the quick filter tooltip showing which sheets they are applied. That wasn't something I ever saw advertised
You've got a tough red pill!
What about parameters, sets, and actions?
In workbooks I've inherited from others I've often had to unhide them (not sure why they were hidden) to see what is going on. I've actually had a few that were the problem.
I've noticed the same behaviour recently,
it may be specific to the exact (10.1.x) version.
Which one do you have installed?
And what is the primary datasource
of the view in question?
PS No harm so far from those Red Pills :-)
If you've upgraded and haven't changed anything in the workbook and something is broken then I suggest you submit this to Tableau support. The Tableau devs really want to avoid breaking workbooks on upgrades.
It was 10.1.1 but I just downloaded 10.1.3 as I see it was released yesterday. I still get the same result. The data source is a published data source on Tableau server (from MS SQL Server). I will take Jonathan's advice, although it really isn't causing me any issue other than the color is wrong.
The mysterious Red Pill is evident
when you're opening a view inside
a 9.x workbook in 10.x version of TD.
Besides, the view should be constructed
to contain at least the following objects:
1. Two+ Green Pills (having their own Mark Shelves)
with at least one Mark Shelf as either Line or Shape --
so either Path or Shape control is active for at least one Pill.
2. The Pills on either Path or Shape should be different
on each Mark shelf, better to have one of the shelves
a different Mark type (Bar, Area, Circle etc).
3. Opening such 9.x view in 10.x TD triggers Red Pill on All shelf.
Please find the attached sample v9.3 workbook as an example.
Shape_Path_9.3_YF.twbx 1.2 MB
Thanks Yuri for researching this! I think I follow as I have something similar to your workbook with 4 mark shelves two of which have nothing on LOD card.
This is interesting and I'm sure will get more attention as workbooks with these conditions start migrating to 10.
John, you're welcome.
Please let me know if you'd find something.