Zack- Hard to tell without looking at workbook. But here's something you could try, open a new worksheet and drop the calc field and number of records on to the view to confirm if all fields have values associated. Then go back to your original view (where the graphs disappearing) and see if "Recent Expired Date" is in filters. If this didn't work, please mock up some data and attach a packaged workbook so someone can assist you.
Thanks Shiva I will check that out - do you know if I can omit 'expired' data somehow in my calculated field? could that be a work around?
If you're not going to care about the 'expired' data then I don't see a reason why you need it in calc. This also eliminates the need of Set. Give it a try.
Removed the "Expired" line in the calculated field but I believe the information is still there at the end under 'Else' ... any idea how to remove expired data completely?
If you don't want the 'expired' data to flow in at all, then use a data source filter and filter out that data. There is one way I could think of,
1) Create a calc 'Future Dates' like so, this will create a boolean filter with True, False.
[Recent Expired Date] >= Today()
Exact Dates start from,
2) If you want to filter this data at data source level itself, then add a datasource filter,
Hit OK, your data is updated.
3) Now in your worksheet, the data never shows up and avoids the usage of future dates filter explicitly.
Now you can play with existing data as you like. Do you think this would work? Not smart but hope this works.
UPDATED: Be cautious that a data source filter affects entire workbook.