2 of 2 people found this helpful
Hey Stephen Fielder I am able to replicate the issue. What I was able to discover was that for some reason the Program Four Consent Program is the contributing factor. November 27th disappears when this Program is not selected in the filter. I see that [Sent ] has all 0 values for that time period, which at first I thought might have something to do with it, but because both Nov. 6th and Oct 30 have 0 in [Sent ] I don't really think that is the issue. Also, another confusing point is that when I try to view all data, I get nothing but zeroes. I wish I could help more, and perhaps my comments here can assist.
1 of 1 people found this helpful
Thanks very much for looking at this for me - it's helpful to know that I'm not going mad and the problem is genuine and not just because I'm relatively new to Tableau.
I've opened a support case with Tableau for this now I've worked out how to do this. They've replied to say that the problem could be because I'm using Data Blending rather than Joins to link my tables. So I recreated the table using joins, but I think I need a full outer join as there may be days when one or other of [Sent ] and [Total Leads ] doesn't have data points as nothing is recorded - e.g. Saturdays when we don't mail but do receive calls.
It looks like full outer joins are only available for .csv data sources and I'm using an Access DB. So I'm a little stuck at the moment.
I'll leave this open for now and see if anyone else can think of any good ideas.