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?

       

      Thanks

       

      Added sample workbook

       

      Fixed the attachment