Chart depending on "if then" date comparison

[#1]

I would like to show depending on a date comparison a donut chart. The followin expression gives me a bogus result:

f((Date#(today(1),'DD.MM.YYYY')=>[DueDate]),Count([ActionPointID]))

For a bar chart I used the following exspression, which does work just fine with the same data:

if((Date#(today(1),'DD.MM.YYYY')>=[DueDate]),MonthName(Date#([DueDate],'DD.MM.YYYY')))

What do I miss?

Thank you

[#2 · Accepted solution]

Just got it fixed:

Count(if((Date#(today(1),'DD.MM.YYYY')>=[DueDate]),[ActionPointID]))

The Count() statement needs to wrap everything.

[kaushiknsolanki]

Hi,

Check the sign '=>' it should be  '>=' instead of '=>'

Regards,

Kaushik Solanki

[sunny_talwar]

Do you have a sample you can share? Not sure I understand what the issue is?

[sunny_talwar]

In this case, I would suggest using set analysis:

Count({<DueDate = {"$(='<=' & Date(Today(1), 'DD.MM.YYYY'))"}>} [ActionPointID]))

[kaushiknsolanki]

Please mark the post as answered.

Regards,

Kaushik Solanki