How to distinct count ?

stighy — Sun, 12 Mar 2023 20:44:29 GMT

I've a table like this :

Year; Patient; City; Visit; Revenue

And some data like:

2021; Mike; NYC; ABC; 100
2021; Mike; NYC; CDE; 50
2021; John; NYC; FZX; 40
2021; John; NYC; AGA; 10
2021; Frank; Los Angeles; JJK; 20

I want to show a table with:
City; Nr Distinct Patient; Total Revenue

So
NYC; 2; 200
Los Angeles; 1;20

I don't know how to distinct count Patient.
Using: COUNT(Distinct Patient) not work!!!

Thanks

Re: How to distinct count ?

Lisa_P — Sun, 12 Mar 2023 23:20:58 GMT

This works in table in sheet, are you trying to do this in the load script ?

topic Re: How to distinct count ? in App Development

How to distinct count ?

Re: How to distinct count ?