Asking a custom question
In the last section, we learned that the Simple question feature offers ways to build a question based on a single table and an optional filter, summary function, and grouping. This will work great for many of your most important questions, but it will only be a matter of time until the complexities of your question can no longer be addressed by the Simple question feature. When that happens, your next best option is the Custom question feature. Let's learn about it and answer the second question, Who are our top customers?
First off, let's think about what a "top customer" is. Are they our customers with the most orders? The most items ordered? The most money spent? The most money spent in the last 90 days? As analysts and data scientists, we are all too familiar with seemingly simple questions turning out to be too vague and underdefined. For now, let's define our top customers as those with the most orders, and limit those customers...