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*