Skip to content

Frequency

Scenario

What are the net numbers of bookings per person once bookings to the US have been removed?

  • Click on the Add Aggregation button

  • Click on the tab entitled Frequency(Communications)

    Note

    The auto-naming feature will populate the Name box until you change it - see below.

  • Leave Type as Frequency

  • Set the Grouping Table to People and the Transactional Table to Bookings

  • Create a selection that identifies Non US Bookings and drag it onto the filter box

  • Change the Name to display Total Bookings excluding US

  • Click the Build button to see a preview of the results

A Data Grid can be used to validate the results: