countdistinctamazon-quicksightdistinct-values
QuickSight - count distinct of two columns
I need help with figuring out how to perform count distinct over two columns in QuickSight - find the number of unique combinations of values from two columns. Example below would result in 4
| column1 | center |
|---|---|
| apple | 87 |
| apple | 87 |
| banana | 34 |
| blueberry | 45 |
| blueberry | 32 |
Solution
There are different ways to do it. You can simply put the center field in a field well and use the Count distinct aggregation as shown below
Alternatively, you can create a calculated field for this count with the following definition:
distinct_count({center})
- COUNT where SUM condition using DQL
- Return total number of rows found while paging in JAX-RS resource
- Counting all "-1" and -1 in a dataframe for a list of certain columns
- Equivalent of FOUND_ROWS() function in Postgresql
- Count number of query results in a CodeIgniter application
- Get all persons as a sum from all WooCommerce bookings
- Getting a count dynamically for Customers first time orders and also orders lost after last order date + 4 months, per year and month
- In MongoDB's pymongo, how do I do a count()?
- Count number of occurrences of each unique element in a list in ansible
- How select query from record count more than 1 and count more than 2 with custom column (Option) in MS Access
- Count particular characters within a column using Spark Dataframe API
- Google Sheets: Formula requires Complex Logic regarding dates
- Return count of qualifying rows from a SELECT query with a JOIN using CodeIgniter
- Select COUNT(*) of subquery without running it twice
- Performing a query on a result from another query?
- Display table rows with the per-row count of another table using CodeIgniter
- get count of each users role
- How can I hide the total count in changelist_view (Django admin)?
- Add span to archive post count
- MySQL - select rows where count in joined table equals 1
- Why does CountA give me more results than using FILTER with either NOT(ISBLANK or <>""
- How to add a COUNT column as a subquery in MySQL
- How can I create a separate count for supplementary figures?
- Count number of occurences for each unique value
- How to count a nested collection in a List with Java Streams
- In R, how do you find the number of different values between 2 character strings?
- How to count on a group by array_agg in PostgreSQL
- Excel: Count text occurrences within a Range, when two or more text items are present
- SQL query to get the number of customers who purchased on multiple dates
- How to count if a product is bought on the same day, by the same person, together with another product?