Till Yesterday Count.

[#1]

Hi All ,

Can any one help me with YTD logic

I need to take count of ID's till yesterday .

My data is from 1st May , 2016

I need the count of all ID's till yesterday i.e from 1st May to 14-06-2016 .(day before current date) in set analysis.

[sunny_talwar]

May be like this:

Count({<Date = {"$(='<=' & Date(Today() - 1, 'DD-MM-YYYY'))"}>} ID)

Or this for a distinct count:

Count(DISTINCT {<Date = {"$(='<=' & Date(Today() - 1, 'DD-MM-YYYY'))"}>} ID)

[PrashantSangle]

hi,

or may be

count({<DateField={"$(<=Date(Today()-1))"}>}Distinct id)

careful with date format while comparing.

Regards

[sunny_talwar]

You mean this max?

Count({<DateField={"<=$(=Date(Today()-1))"}>}Distinct id)

[PrashantSangle]

yes..

my bad.

thanks for correcting.

Regards

[#6]

Hi Sunny,

I tried your solution but, nothing is coming.

Let me explain you again my requirement :

I have my data from 1st May 2016. I want count of all ID's from 1st May till yesterday i.e 14th June 2016.

Reply ASAP..!!

Thanks,

Ashvita

[sunny_talwar]

What is your date field format? Can you share screenshots or a sample qvw to look at?

[#8]

Hi Sunny,

My Date format is 'MM/DD/YYYY'.

Thanks,

Ashvita.

[PrashantSangle · Accepted solution]

Hi,

then modify expression as per date format you have.

Try like

Sunny Expression

May be like this:

Count({<Date = {"$(='<=' & Date(Today() - 1, 'MM/DD/YYYY'))"}>} ID)

Or this for a distinct count:

Count(DISTINCT {<Date = {"$(='<=' & Date(Today() - 1, 'MM/DD/YYYY'))"}>} ID)

or in my expression

Count({<DateField={"<=$(=Date(Today()-1,'MM/DD/YYYY'))"}>}Distinct id)

Regards

[#10]

Hi All,

Thanks Sunny and Max Dreamer for solution.

Its Working..

Warm Regards,

Ashvita.