http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help Topic: count unique values en Sat, 11 Sep 2010 01:54:31 +0000 http://dashboard.infocaptor.com/topic/count-unique-values#post-63 Tue, 28 Apr 2009 21:07:02 +0000 admin 63@http://dashboard.infocaptor.com/ <p>Hi,</p> <p>In the InfoCaptor example dashboard there is a column called country_name. You can get a list of all unique countries by issuing a SQL statement like</p> <p>select distinct country_name from [detail_data$]</p> <p>Now to get a count of all these unique values you can wrap it under an inner table like below</p> <p>select count(*) as total_country<br /> from<br /> (<br /> select distinct country_name as country<br /> from [detail_data$]<br /> ) </p> http://dashboard.infocaptor.com/topic/count-unique-values#post-61 Tue, 28 Apr 2009 06:24:12 +0000 S Uma 61@http://dashboard.infocaptor.com/ <p>What is the sql statement to be used for counting unique values in excel </p>