Individual and set analysis condition value not matching

[IAMSIVA]

Hi All,

Please help me with the below expression for my calculation.

Expression works if i use the below logic: (individual dates) and the value is 2875

Count(distinct {<[Date] = {"10/25/2019"},Flag={'NEW'}>}id)
+
Count(distinct {<[Date] = {"11/1/2019"},Flag={'NEW'}>}id)
+
Count(distinct {<[Date] = {"11/8/2019"},Flag={'NEW'}>}id)
+
Count(distinct {<[Date] = {"11/15/2019"},Flag={'NEW'}>}id)
+
Count(distinct {<[Date] = {"10/25/2019"},Flag={'REPEAT'}>}id)
+
Count(distinct {<[Date] = {"11/1/2019"},Flag={'REPEAT'}>}id)
+
Count(distinct {<[Date] = {"11/8/2019"},Flag={'REPEAT'}>}id)
+
Count(distinct {<[Date] = {"11/15/2019"},Flag={'REPEAT'}>}id)

And has difference in value if i use the below logic: and the value is 2481

Count(distinct {<[Date] = {">=10/25/2019<=11/15/2019"},Flag={'NEW'}>}id)

+

Count(distinct {<[Date] = {">=10/25/2019<=11/15/2019"},Flag={'REPEAT'}>}id)

and the date format is MM/DD/YYYY and the correct value is 2875 and not 2481.

can you correct me if there is any issue with the > and < condition.

[Arthur_Fong]

Try this:

sum(aggr(Count(distinct {<[Date] = {">=10/25/2019<=11/15/2019"},Flag={'NEW'}>}id),Date))

+

sum(aggr(Count(distinct {<[Date] = {">=10/25/2019<=11/15/2019"},Flag={'REPEAT'}>}id),Date))

[Kushal_Chawda]

Try this

Count(distinct {<[Date] = {">=10/25/2019<=11/15/2019"},Flag={'NEW','REPEAT'}>}id)

[Anil_Babu_Samineni]

Perhaps this

Count(distinct {<[Date] = {"10/25/2019", "11/1/2019", "11/8/2019", "11/15/2019"},Flag={'NEW', 'REPEAT'}>}id)