1 Reply Latest reply on Oct 31, 2018 1:42 PM by Patrick A Van Der Hyde

    Multiple Dynamic filters based on a single user selection

    Bronwen Smith

      Version: 2018.1.4

      Datasource: Cube

       

      Hi to all the brilliant Tableau developers out there. I've recently started my tableau journey but am working on a cube. I unfortunately cannot attach the workbook due to non-disclosure, but I hope I can describe the problem I'm having accurately enough to get some help. I'm beginning to wish I could go back to SSRS (!!).

       

      The information on the Dashboard is all based on the year - current year for some, current year vs previous year for others, and in still others, the last 10 years. The Dashboard as stand alone is fine, but now of course I've been tasked with making it dynamic. The client wants to choose which year of data to be displayed, and want a drop down box with the list of valid years (i.e. no future data) to be able to select the year which then needs to merrily filter down and adjust the graphs and charts accordingly. I'd be lying if I said I even knew where to start, or even whether it's possible, since the year is a dimension. To make matters worse, there are about 30 sheets behind the scenes making up the dashboard, and I have to be super careful to apply the right year to the right sheet, otherwise it all falls apart.

       

      Really hope someone brilliant out there has some good ideas!


      Thanks in advance

        • 1. Re: Multiple Dynamic filters based on a single user selection
          Patrick A Van Der Hyde

          Hello Bronwen,

           

          This sounds like a challenging customer issue that may require consultant time or some time with our Analytics support team to assist.  You could open a ticket at https://support.tableau.com but they are very limited on time so one other option is Tableau (or another firm) consulting services?   This would really take some digging into with the cube data.

           

          Only options that I can think of without a look at the workbook - check out Sheet Selection on Steroids or a tool to extract the data needed from the Cube into a more friendly db. 

           

          Oh and the type of cube would be helpful to share.  There are differences that our audience will be more knowledgeable about if you share the specific cube type.

           

          Thanks

           

          Patrick