Skip to main content

Level 1 - Question 9

Question

Build an Explore query using number view that will return an average of age filtered to events with action that matches purchase starting 1 month ago and ending now.

Take Note:

Once your query returns pay attention to the numeric value. Because we chose average of age instead of count of events our measure 1 is instructing the query to look for all unique values of age within the given time range (here we chose 1 month ago to now) and summing it then dividing it to returning the average value for measure 1.

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*

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.