6 Replies Latest reply on Jan 16, 2018 5:04 AM by Michal Mokwinski

    Counting elements

    Avi Meir

      Hi everyone, I have the following dataset:


      Screenshot 2018-01-16 10.42.48.png


      Each trip can have 1 or more bookings, and each booking can be of type hotel or flight.


      I am trying to figure out what % of trips have only one flight booking, only one hotel booking or multiple bookings of hotel and flight. Note that if the trip has multiple bookings of the same type, I want to consider it as if it had only one booking of that type.


      Any ideas how to get to this result?




      Added sample workbook


      Fixed the attachment