The task at hand is to plot the number buys in each media type (Newspaper, TV, Magazine, etc) for the last five years. In a line chart, I set a dimension of year and a measure of type. I created a measure for each type and created an expression such as: if (pubType='TV',aggr(count(pubType),jobYear),0))
This seems to work if a salesperson has buys of only one media type, if they have buys for 2015 in newspaper and TV, it plots nothing.
I have played with some set analysis expressions but can’t seem to get past this issue.
The attached image shows 3 newspaper buys in 2015 and 7 in 2014. 2013 should show 8 billboard, 1 newspaper and 1 online. It is at this point that my expression breaks.
Can anyone point me in the right direction on this one?