Creating a bar chart from a merged query

[kirstens-164252]

Hello,

Is it possible to create a stacked bar chart from a merged query if the two dimensions I want to use are in two different models? It may be relevant also to say that I do not want to use the field that I am joining the models on in the bar chart (which in this case is application number).

Here is a screenshot of what I’m trying to do and the error I am getting:

I would like to have the calculated field “Insurance Sold By Name” as the x-axis, the count of loan accounts as the y-axis, and a stacked bar chart for each seller’s name that breaks down how many of each payment protection plan they sold (the pivoted field).

Here is the LookML of the calculated field (Insurance Sold By Name): 

Thanks in advance!