3 Replies Latest reply on Nov 13, 2018 11:54 AM by Egor Larin

    Complex scenario: Date Quick Filter Logic (Populate the months of recent year in quick filters )

    DHRITIMAN BANERJEE

      Hi Community,

       

      I have  a complex scenario and I am using tableau 10.2

      date filter.PNG

       

      I have used LOD to get the maximum process date of the years related to policies in insurance domain.

       

      I need a quick month filter logic referring to processdate using calculated field or any other way where it will populate months  upto January to March because I want to populate the months for 2018(Current year) only as March 5,2018 is the maximum process date of current year. The other months which exceeds the month  of maximum(March of 2018 ) process date of current year should not be populated in quick filters .

       

      I have attached the tableau workbook for your reference. Could you please give me suggestions or logic as it is urgent delivery.

       

      Regards,

      Dhritiman