Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What exactly are you hoping from the script?
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
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
My test qvw @ stalwar1
So the chart we are seeing (bar chart) isn't right? What do you want to see instead?
The counts for employee in bar chart is not matching the Enddates filter on the right.
If you select the first employee, the bar chart count is 19 and the Enddate count in filter is 11
Are you looking for a DISTINCT count of ENDDATE may be?
Count({$<ENDDATE = {">=$(=Date(Today(), 'YYYY-MM-DD'))"}>} DISTINCT ENDDATE)
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.
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