Doing distinct count

Hello Helical Insight,

I am using helical insight enterprise edition 4.1 GA. I want to know how can we do distinct count. Using adhoc report

Thank You,
Sesa.

Hello Sesa,

In the adhoc interface you have various kind of aggregate functions which can be applied. Over there you can select both distrinct and unique. Make sure you click on first distinct and then count since the sequence in which you click on these will accordingly make the SQL

image

Thank You,
Helical Insight.