4 Replies Latest reply on Feb 18, 2018 12:47 AM by ammar.khwaira

    Relative Date Filter on multiple dates (OR Operation)

    ammar.khwaira

      Hi

       

      I have orders with order_date and pickup_date (see all_orders sheet). I want to show a Relative date filter in which it is applied on both dates (order_date and pickup_date using OR operation).

          

      order noorder_datepickup_date
      11-Feb-182-Feb-18
      228-Jan-181-Feb-18

       

      For example, if i choose "Month To Date"  (1-Feb-2018 To 15-Feb-2018) , Tableau is filtering orders based on order_date, thus showing only order no 1(See filtered_orders sheet).

      What i want to show is both orders , based on the following calculation:

       

      if order_date this month, OR , pickup_date this month then show order. 

       

       

      Thanks