2 Replies Latest reply on Nov 3, 2013 9:27 PM by Warren Bromfield

    Dual Date filters

    c n

      Hi,

       

      I want to apply two different date filters to two SEPERATE measures for my display. I am having trouble making this work because BOTH date filters seem to be affecting EACH measure.

       

      Is anyone aware of any tricks/techniques to acehieve my aim?

       

      C.

        • 1. Re: Dual Date filters
          kevin.lynch

          Hi,

           

          Could you post a packaged workbook to show what you are looking for? If the data is sensitive then maybe you could mock it up using the Tableau sample data sets.

           

          It will make it much easier to try and solve your problem

           

          Thanks,

          Kevin

          • 2. Re: Dual Date filters
            Warren Bromfield

            Hi C.

             

            You can do this using two separate calculated fields and parameters(rather than filters) for example:

             

            Calculated field 1: if date_value = "date parameter 1" then measure1 else 0 end

            Calculated field 2: if date_value = "date parameter 2" then measure2 else 0 end

             

            I attached a quick mock up as an example (please excuse all typos in there :-) )

             

            Thanks,

            Warren