Counting distinct strings in a column

Question & Answer
,
1

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

2

Hi @btenneson
please have a look at

BR

3

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?

4
5

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 much obliged.

Thanks

Thanks,

Brian Tenneson (he/him)
Graduate Student
Department of Applied Data Science
Bay Path University

P.S. My timezone is PST which is GMT -8:00.

6

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

7

You have to create a calculated field.
grafik