Data not breaking down by Month

[fwa]

I have spent hours trying to break down the spent/cost column by month. It is showing some "random" data for every month. The "Total Spent" column takes it's data from three sources (2 Google Ads + 1 Meta accounts). The "Total Sales" column is correct which is not a custom field.

The default data range for the Pivot table is set to "custom" (This Year)

Thanks already to anyone who can help!

[ArkadyZagdan]

You shhould elaborate more about your data sources. Table schhemas and how its being plugged into LS.
Othehriwse hhard to troubleshoot.

[shijithpulikkal]

Hi,

you need to share the blending details of ad spent to find out the issue, what kind of joins used and how many join keys are there

Shijith Pulikkal - Xtract Studio

[fwa]

See attached the blended data that is being used. Shopify data is working fine ("Total Sales" row), Google and Facebook data is correct but reflecting each month is not working. 

[shijithpulikkal]

Hi,

instead of using cross join blend them with left outer join and use only date as join key between the blends

and see the results

Shijith Pulikkal - Xtract Studio

[fwa]

Unfortunately that results in an error, see below.

Any other ideas?

[shijithpulikkal]

you have not set it up properly.. you have to include date fields in dimension area for all datasources and data blending is left outer join.. if you want you can share the dashboard also so i will update it.

[fwa]

Anyone else has an idea what the issue could be?
Thanks