Greater than today date

[MK9885]

Hi,

I've a requirement where I need to show the count where the dates are greater than today.

I've a field name ENDDDATE and I've to count the ENDDATE where it is greater than today date.

I've tried count({<Date={">=Today())>ENDDATE"}>}distinct( Dimension))

and

Count({$<ENDDATE={">=$(date(Today())"} >} Dimension) but the count doesn't matches for some reason.

Can anyone please help?

And my DateFormat='YYYY-MM-DD' both in script and master calendar.

stalwar1‌swuehl‌loveisfail‌

[sunny_talwar]

What exactly are you hoping from the script?

[MK9885]

I just gave you my Master Calendar script to verify if I've done it correctly?

But my aim is to show the Count of dates > today

[sunny_talwar]

Got it, I think it would be more helpful if you can share a sample with the expected output

Preparing examples for Upload - Reduction and Data Scrambling

[MK9885]

My test qvw @ stalwar1‌

[sunny_talwar]

So the chart we are seeing (bar chart) isn't right? What do you want to see instead?

[MK9885]

The counts for employee in bar chart is not matching the Enddates filter on the right.

[MK9885]

If you select the first employee, the bar chart count is 19 and the Enddate count in filter is 11

[sunny_talwar · Accepted solution]

Are you looking for a DISTINCT count of ENDDATE may be?

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

[MK9885]

I tried with the above expression you gave but it still doesn't matches the EndDate count.

Because all of the enddates are for 2017.

[sunny_talwar]

arvind654 -

Bro, I am confused

1) I don't see 19 for the first Employee, I am seeing 18 instead. After using the new expression I see 9 which matches the end dates after today

Now can you explain me what exactly are you looking to see