Using Quicksight, I have a dataset consisting of police crime statistics and wish to know how many different strings are in the column marked “Neighborhood.” How do I do this in quicksight? This is the first time I have used quicksight. TIA

You have to create a calculated field. [grafik]

Hi @btenneson please have a look at distinct_count - Amazon QuickSight Use the distinct_count function for calculated fields in Amazon QuickSight analyses. BR

Hello, I see syntax for that command looks like this: distinct_count({Order Date}) But where do I enter that command? Does it go into an entry in the table?

[image] Quick Sight: Basic Calculations: 2023 Amazon Quick Sight Learning Series Videos [Basic Calculations: 2023 Amazon QuickSight Learning Series] This is a companion discussion topic for the original entry at https://www.youtube.com/watch?v=KPBHp3…

Can you please narrow down the 35 minute video or tell me where the total number of strings is counted. In my example, I have a 100+MB CSV and there is a column called neighborhood. How do I calculate how many distinct neighborhoods there are. If you could tell me where this is in the video I’d be m…

So you don’t know where in the 35 minute video what the information is?

Counting distinct strings in a column

Q&A

ErikG March 14, 2024, 2:51pm 4

Topic		Replies	Views
TOTAL Calculation Q&A formatting , quick-sight , Business-Intelligence-Engineer	6	121	January 24, 2025
Total count of a dimension Q&A quick-sight , calculations	1	291	June 18, 2023
Distinct Count LAC Workaround Q&A analysis , Business-Intelligence-Engineer	5	75	May 20, 2026
Please Contact the Quicksight Team to solve this issue Q&A analysis , quick-sight , calculations	3	1038	October 14, 2022
Calculated Field for distinct key column Q&A analysis , quick-sight , calculations	3	1022	November 1, 2022

Counting distinct strings in a column

Related topics