I’m using a method by Jeff Pettiross to dynamically select and display sheets on a dashboard. The problem that I’m having is that an important quick filter and color legend only show up properly on one of the selected sheets, but not the other (the quick filter and the color lengend's container titles are there, but both have an empty list of items).
Yesterday I received some tremendous help from John Abdo, Dan Cory (From Tableau), and Joe Mako on how to display some job data by date and time. It was a problem that seemed (to me) to be simple when I first approached it, but turned out to be beyond my abilities. You can read the full posting by clicking here.
Once I adapted John, Dan, and Joe’s solution to my actual data, I showed it to the business. They really liked it, but asked if they could see not only jobs by date, but also dates by job, and they wanted to have them on the same dashboard, and have the ability to choose which one they wanted to see.
I went back to the forums, and I found a very ingenious tutorial on how to dynamically display and hide sheets on a dashboard by Jeff Pettiross (from Tableau). You can find his tutorial in this posting, about 30% down the page.
I followed Jeff’s method (which works very well), but the problem that I’m having now is that some of the filters and the legends only show up when one of the sheets is selected. For example, when I select Jobs by Date, I can properly see my Job Name filter and my Job Success color legend, but when I select Dates by Job, there are no items in the Job Name filter and Job Success color legend.
I’ve produced an example workbook and some screen shots to illustrate my problem. If someone could nudge my brain in the right direction, I would greatly appreciate it.