Question

Build an Explore query that uses number view that returns the sum of price, filtered to actions that match purchase, starting 1 day ago and ending now.

Take Note:

Similar to questions 9 and 10 where we used an average operator; in question 14 we’re using a sum operator instead of a count operator. This will allow us to determine the sum of any field that has integers. You might also notice that the dropdown of what you're wishing to sum includes a bit of a different list than what populates if you use a count operator. This is because sum is only able to be ran against integer values so any strings have been omitted. In this case we’ll also want to format the results as a currency because we want to determine the amount of dollars that have been spent on purchases.

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*