3 Replies Latest reply on Jun 30, 2018 4:33 AM by Naina Singh

    Multiple orders and order statuses per customer - grouping question

    Naina Singh

      Hi all,

       

      I have been struggling to combine multiple orders and statuses per customer into a single view. What I'd like to do is visualize customers who have made orders that have been accepted and rejected within a given time frame.

       

      My data looks something like this:

      Order IdCustomer IDStatusDate Created
      11Accepted1/1/2018
      21Rejected2/1/2018
      32Accepted3/1/2018

      4

      2Accepted4/1/2018
      53Rejected5/1/2018
      63Accepted6/1/2018

       

      I'd like to be able to view it so that I can see only those customers that have accepted and rejected. I'm doing this because I want to analyze this group of customers but I can't find a way to group them using filters.

       

      I'd like to be able to create this final view through a Boolean.

       

      Customer IDAccepted and Rejected?
      1TRUE
      3TRUE