To answer this question, we need to retrieve the number of unique entries in the User table. By definition, there is a 1-1 relationship between each primary key entry and each user account. As such, performing a COUNT function on the User_ID field will give us the correct response. To perform this function, drag the user_id field into the Measures box of the Chart Creator and click on the blue box to pick the proper function. As a best practice when counting distinct values, even if counting the primary key, select the count unique aggregation function in Chartio.
- Aggregation Function: Count (Distinct user_id)
Interactive Mode Configuration and Sample Answer:
SELECT COUNT(DISTINCT "us0"."user_id") AS "Count of Users" FROM "public"."users" AS "us0" LIMIT 1000;