An executive wants a monthly report that shows the number of different customers who placed orders, while avoiding duplicates. Which measure is recommended?
A distinct count ensures each customer ID is only counted once, which addresses the need to avoid counting duplicates. Summing up orders or calculating an average would count multiple purchases from the same customer more than once, and finding the maximum ID has no value in revealing the total of different buyers.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does 'distinct count' mean in data analysis?
Open an interactive chat with Bash
Why is the average transaction size not suitable for tracking unique customers?
Open an interactive chat with Bash
How can duplicates affect the accuracy of business reports?