Now I am trying to visualize the effect of the social marketing campaign.
The input file merges the data from 2 tables, which is the sales dataset and promotion dataset
In the sales dataset, there is a timestamp, which shows the date of purchase
In the promotion dataset, there is a timestamp, which shows when the promotion is published
And the outcome would be similar as follows
|Purchase date||Promotion date||Campaign|
Now I have a graph for the sales
The question is, I would like to show the activity in different month
i.e a 2 line in a graph, to show how many purchase and how many promotions are published in Jan-2018, let say
But the information is from 2 different column. Is it possible to do that? If yes then how can I make it?
Many thanks for your help in advance!