Count a data item occurence within a date range

[dwong11229]

Hi

How to count data item within a date range

I have NameId data item and a Creation date data item

I want to count the number of NameID that is between 2018 and 2017

So lets say NameID appeared in date range between 2017 and 2018 have three NameID
The end result will be 3.


Thanks

[Lynn]

Hi

How to count data item within a date range

I have NameId data item and a Creation date data item

I want to count the number of NameID that is between 2018 and 2017

So lets say NameID appeared in date range between 2017 and 2018 have three NameID
The end result will be 3.


Thanks

Assuming your package is relational, try something like this:

Code Select Expand


count ( case when [Creation date] between 2017-01-01 and 2018-12-31 then [NameID] else null )