Is it possible to write count(distinct Tickets ID) in model level

[#1]

Is it possible to write count(distinct Tickets ID) in data model level??

[marcus_sommer]

Surely, but the whole load-statement needs to be adjusted to such a calculation. It should look like:

count:

Load AnyGroup, count(distinct [Tickets ID]) as TicketCount From xyz Group by AnyGroup;

- Marcus

[tresesco]

Possible. Try like:

Load

          Field1,

          Field2,

          Count( Distinct Field3) as Count

From <> Group By Field1, Field2;

[sunny_talwar]

Not sure what you mean when you say Data Model level? Do you mean to do this in the script?

[#5]

Yes it is script level