Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
Try this
Count(distinct {<[Date] = {">=10/25/2019<=11/15/2019"},Flag={'NEW','REPEAT'}>}id)
Perhaps this
Count(distinct {<[Date] = {"10/25/2019", "11/1/2019", "11/8/2019", "11/15/2019"},Flag={'NEW', 'REPEAT'}>}id)