I need to create a chart (Line or Bar) to show daily sales using the available dataset. But I also keep another table to store the dates of Weekly marketing campaigns. Now I want to highlight the daily sales chart with campaign dates (Possibly a bubble on the chart) to help analyzing the impact of marketing campaign in sales.
2 Comments
- I recommend doing a single date dimension and implementing your business specific events in that model. You could also achieve same effect by keeping your separate event table and adding a key field in date dimension. Use bi-direction filter between date and event tables. Now you can filter on event name which would filter corresponding dates.
- Status added:Needs Votes
