#14265: Add support for Count Distinct -- COUNTD | Aqua Data Studio

Issues
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 828

IDE for Relational Databases

Back

Sachin Prakash

SachinPrakash reported Feb 8, 2016 · tariqrahiman last modified Mar 30, 2016

Add support for Count Distinct -- COUNTD

customer request

Dev	nhilam
QA	SachinPrakash

Priority	Major
Complexity	Unknown

Component	Visual Analytics
Version	17.0

We currently have a COUNT function which returns the number of items in a group. NULL values are not counted.

We want a new function called COUNTD which returns the number of unique items in a group. NULL values are not counted.

4 attachments

COUNTD_v17.0.3-2.png

Mar 9, 2016

46 KB
COUNTD_v17.0.3-2.vizx

Mar 9, 2016

363 KB
COUNTD_Calc_Field.png

Mar 9, 2016

27 KB
defaultproperties_aggregation.png

Mar 9, 2016

56 KB

All Comments Change History (4)

Nhi Lam

nhilam Feb 16, 2016

Field	Old Value	New Value
Fixed Build		17.0.4-1
Resolution		Fixed
Resolved Date		Feb 16, 2016 6:05 PM
Status	New	Resolved

Sachin Prakash

SachinPrakash Feb 16, 2016

Field	Old Value	New Value
Fixed Build	17.0.4-1	17.0.3-2

Abhishek Joshi

abhishekj(*) Mar 9, 2016

Field	Old Value	New Value
Status	Resolved	Verified

Tariq Rahiman

tariqrahiman Mar 30, 2016

Field	Old Value	New Value
Status	Verified	Closed

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017