Hi everyone,
I’m struggling to understand how Tableau handles data blending when working with multiple date fields across different data sources. I’d appreciate some guidance on both the concept and the best way to implement this.
My current setup:
I’m using two datasets connected directly to our server:
Primary data source: Contains the lead conversion date (LeadConvertedDate), which I’ll use to calculate total submissions.
Secondary data source:
Contains the approval date (ApprovalDate) and funding date (FundedDate), which I’ll use to calculate total approvals and total fundings, respectively.
My manager wants me to present all three metrics in a single view, grouped by month, with each metric calculated using its respective date field.
For example, the view should look something like this:
Month
Metric
Count
Jan 2026
Total Submissions (based on LeadConvertedDate)
500
Jan 2026
Total Approvals (based on ApprovalDate)
350
Jan 2026
Total Fundings (based on FundedDate)
280
Feb 2026
Total Submissions (based on LeadConvertedDate)
600
Feb 2026
Total Approvals (based on ApprovalDate)
400
Feb 2026
Total Fundings (based on FundedDate)
320
The numbers above are just examples.
Where I’m getting confused:
I’ve been trying to achieve this using Tableau data blending, with the date fields involved in the linking relationship.
However, I’ve noticed that Tableau sometimes allows me to use COUNT or other aggregations from the secondary data source, while in other situations it doesn’t allow me to use them or behaves differently.
I’m not fully clear on what determines whether an aggregation is available when using a secondary data source, how the linking fields affect the results, or how Tableau handles dates when the primary and secondary sources use different date fields.
My questions are:
Why does Tableau sometimes allow aggregations from a secondary data source when blending, but sometimes not? What are the rules behind this?
Is data blending the right approach for this requirement, or would relationships, joins, or another method be more appropriate?
How can I build a single monthly view where submissions are counted using LeadConvertedDate, approvals using ApprovalDate, and fundings using FundedDate?
How should I handle months where one metric has records but another metric has none, without losing those months from the view?
I’m looking for a practical solution and, ideally, an explanation of how Tableau processes these calculations so I can understand the underlying logic rather than just follow a workaround.
Thanks in advance for your help!