Last Modified Date: 07 Dec 2017
- In Tableau Desktop, navigate to Data > Edit Relationships.
- In the Relationships dialog box, under Secondary data source select Custom, and then click Add.
- In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. Aggregate the date fields at the MY (month/year) level.
- Edit the source data to ensure that the primary data source has all the data required. In the case of monthly data, each section should have a record for each possible Month and Year combination. Data may be NULL or 0 as needed.
Additional InformationRemoving all date values below the month level allows the date field to be more uniform across data sources.
If deeper granularity than month level data is required, consider using another field for your blend, or, in Tableau Desktop 10.0 and above, joining instead of blending. See Blend your data and Combine tables from different databases for more information.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials