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

    Relative Date Filter on multiple dates (OR Operation)




      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


      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.