Thanks for your reply, the first paragraph of the shared link is about the issue but how can i do that, do you have any idea. Paragraph is below
Groups in the primary data source: If a non-additive aggregation from the primary data source is in the view, you cannot use a group created in the primary data source. To work around this limitation, convert the group to a calculated field.
kindly suggest if there is any other way to use another formula instead of COUNTD.
Kindly provide a sample workbook connected with both the data sources in .twbx format. Also share your expected output.
Sent from my iPhone
I have gone through the workbook shared by you.
It is missing the basic rules of data blending , For example to blend 2 data sets we require to establish a relationship link between both the data sets.
It is mandatory to include this "Common field" on your visualisation/[Sheet] <<JOB ID Missing in your sheets >>.
Its is suggested for you to go though below tutorial .
Its long video but worth watching that clears all your data blending confusions , Hope this will help you
Thanks & regards
Thank you so much for sharing the link, hope this will solve my issue.