Could you please attach your sample data as twbx format.
We don't need actual data, but want mocked up.
Without having a look at the workbook and the data, it's fairly difficult to give detailed advices.
So please attach a sample workbook.
Besides, from your descriptions I suppose,
- You have multiple data sources and data blend is used.
- Your calculated fields have no errors, but don't give correct results.
There's a possibility that
- The relationship settings between the data sources are not correct.
- Linking field settings are not correct.
Also make sure that your date field is date only and not date/time. Even with the DATETRUC the time stamp stays and wont match with unlike field types.
Apologies, I attempted using Sample data included in Tableau but it does not have the same dimensions as my data, and thus wouldn't be an accurate test case. I'd upload my twbx but I am working on a financial project and can't have the information visible. I'll attempt to build a sample data set of older data that I can upload and share.
Yes, my date field is date only. No timestamp.
I have come up with a solution. I'll post it tomorrow.
Thanks for all the help.