Data is matched, why isn't it linked?

[#1]

In the attached file, I'm importing dates and match on field SavedDate. All work fine except for Sunday, October 26th where the date isn't matched.

Where the arrow is the data is missing. The data's week and year is corresponding to the ones listed but still isn't linked and shown.

I suspect this might have to do with the daylight savings time that was changed the week in question. Any ideas what I can do about this?

Thanks

[ali_hijazi]

week 43 in 2014 you have only one date related to this seletion

and there seems no data related to this date and this fine what wrong with this?

[#3]

Thanks for your answer! The SavedDate for this entry is 26.10.2014. This date ought to show up under week 43 in the chart, but doesn't.. Where the arrow is there should be a red box saying 711. You get it if you clear all filters.

[ali_hijazi]

I put sum(VPBacklog) instead and

i get the following if I select 2 dates check current selection box:

and if I clear I get the following result

[#5 · Accepted solution]

Thanks for your suggestion Ali! Sum(VPBacklog) didn't get me what I wanted as it showed the sum of all dates when not filtered, but sum(DISTINCT VPBacklog) did, thanks for putting me on right track!