Dashboard Discussion, Support, Examples, Help » Announcements

count unique values

(2 posts)

  1. S Uma
    Member

    What is the sql statement to be used for counting unique values in excel

    Posted 2 years ago #

  2. admin
    Key Master

    Hi,

    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

    select distinct country_name from [detail_data$]

    Now to get a count of all these unique values you can wrap it under an inner table like below

    select count(*) as total_country
    from
    (
    select distinct country_name as country
    from [detail_data$]
    )

    Posted 2 years ago #

RSS feed for this topic

Reply

You must log in to post.