Showing "non existing" values

Question & Answer
, ,
1

Hi there, I have a list of Brands which have invested in specific marketing strategies.
I in the table below (screenshot) I want to show how much A, B, C and D have invested in each strategy BUT I also want to show where they have NOT invested.
Some brands show a Purchase 0 but this is only because a campaign was created but never delivered.
So for example Brand A should show:
Awareness 46K
Engagement 15K
Purchase 0
Consideration 0

Is there a way to do that in here?
Thanks!!!

image

2

That’s a data preparation task. you need to create a cross join dataset between your all Advertisers and Possible Strategies. Then have that act as Master dataset and do a Left outer join with your fact table based on both Advertiser and Strategy. That should give you what you are looking for. Hope this helps!

2 Likes
3

mmh thanks for the quick answer. Do you think that it could be possible to show this insight by using Narratives? any idea how to implement that instead?