Level 2 - Question 31

Question

Using Explore build a query using the number view that shows an average of total time in the 30 minute session created in question 30. Starting 7 days ago ending now.

Additional Context

Build a query in Explore using number view that shows an average of total time in the Flow you saved from question 30, that is filtered to all events. To build the measure, the default Explore measure reads as count of events filtered to all events, replace events with the Flow you created in question 30, then switch the operator to average and select total time. The query should run from 7 days ago to now.

Take Note:

Flows are most valuable when brought into the Explore builder. In this query were using a previously created flow and using the average operator and its associated functions to automatically determine the average time people spend in the flow.

Solution

Note: The numbers and result does not need to be an exact match as the data changes over time. The query construction is what is most important. See images below.

*Click to enlarge*