You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?
You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?
To determine the number of different types of awards that have been won, you should use the formula COUNTD([Award]). This formula counts the distinct values in the 'Award' field, providing the number of unique award types present in the dataset.
B- Correct answer
To get the number of different types of awards that have been won, you should use the following formula: **B. COUNTD([Award])** This formula counts the distinct values in the "Award" field, giving you the number of different types of awards. Source: Conversation with Copilot, 6/7/2024 (1) . https://www.sportsnet.ca/hockey/juniors/calgary-hitmen-honour-2019-2020-award-winners/. (2) https://www.stpaulstrust.org.uk/st-pauls-school-year-11-leavers-message-2019-2020. https://www.stpaulstrust.org.uk/st-pauls-school-year-11-leavers-message-2019-2020/. (3) https://www.techpointyouth.org/blog/2019/3/13/2019-indiana-vex-robotics-state-championship. https://www.techpointyouth.org/blog/2019/3/13/2019-indiana-vex-robotics-state-championship.
B. COUNTD([Award])