Level 1 - Question 14

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.