I'm noticing you are using the Date field from the secondary data source you are working with. This is indicated by the following icon:
The view you are trying to build will function if you use the date from the primary data source (Shipped):
Let us know if this is clear, or if more explanation is required!
I got the result when we use the month(Date) of primary data source but when I am using the secondary data source I am getting the error. Please help me , I am bit confused why there was an error.
1 of 1 people found this helpful
Very good question. Unfortunately, the benefit of blending comes with some limitation. Especially, where there is non-additive aggregates such as COUNTD, MEDIAN in your secondary data source. Because those aggregates cannot be aggregated along a dimension. There are more other reasons. Please check this out this link that gives reasons why you may get such error so that you will keep in mind the limitation when using data blending.
Very glad, it was useful info. Thank you