How to get the count by equating two date fields

[ravindraa]

Hi all,

I am stuck  in one place please give me any suggestion on this to come out from the issue.

i have 2 date fields "expecteddate" and "deliverykey(Datefield)" field . Also one Dealerkey value .

I have to get the count of Dealer key when the date(expecteddate and deliverydate) are equeal.

We have tried with different expressions but unable to get to exact count.

if the data is sorted in backend that will impact on my entire application i need frent end expression please give me any suggesion.

Kindly suggest some solution for the same.

Please check the below attachments.

Please give me any suggesion.

Thanks in advance.

[Anonymous]

maybe I am looking in the wrong place, but I cannot find "deliverydate" field in your attachments.

[alexandros17]

Use a straight chart

Use Dealerkey as dimension and add the following expresison

Sum(if([Delivery key]=ExpectedDate,1,0))

let me know

[ravindraa]

Sorry , Bill Markham,

Please check now i have modified my mistake .

[ravindraa]

Hi Alessandro Saccone,

  Thanks for helping but it is working for excel data but i have applyed same expression in my app with real time data but it has to be show 495 but it is showing 295, actuvaly i have mentioned same date formate and same fields. pleas give alternative suggision.

Please give any suggesion.

Thansk in advance.