Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Many businesses Sometimes you may want to determine the ratio between two events:

...

  1. Click Explore

  2. To define the first measure, select the appropriate variables from the dropdown lists. We did the following:

    1. Accept the default count aggregation.

    2. Click events and select usernameuser from the dropdown. The text auto updates to Count unique username user actors and f iltered filtered to all username user actors.

    3. Click measure 1 and enter a unique name for the measure. We entered All entered All users.

      Image Added
  3. Click +measure to begin defining measure 2.

    1. For measure 2, select the options from the dropdown lists. We chose to show count unique values of an actor property defined previously, Movies watched over the last 200 daysNumber of searches. We accepted the filter, Filtered to all user actors

    2. Click measure 2 and enter a name. We named the measure Movies watchedSearches.

      Image Added
  4. Click +measure to begin defining measure 3. This measure will be the ratio of the first two measures.

  5. In measure 3, click Count click Count, then type an equals sign. Optionally click the arrow to open the Advanced Operations workspace.

    Image RemovedImage Added

    Type a left bracket [. A dropdown appears containing the first two measures.

    Image Added
  6. Select the numerator from the dropdown listType , then type a slash.

  7. Type a left bracket and select the denominator. Click outside the dropdown to accept the expression.

  8. Accept, or change, the split bySplit ByStarting and Ending values.

  9. Click GO. We received the following results for our example.Click GO to see results.

    Image Added

More information

See Calculate measures and filters for information about building expressions.

...