I am looking for a way to create a cross tab. I want to know how did movies released on different start dates performed during the first 7 days.
I need day 1, day 2, day 3 , day 4 , day 5, day 6, day 7 of all movies aligned one below the other. (Movies will have different start date).
|release date ||movie name||DAY 1||DAY 2||DAY 3||DAY 4||DAY 5 ||DAY 6||DAY 7|
So, similar to the above cross tab : where the numbers are number of tickets sold.
I am able to create a similar viz but, Instead of day 1, day 2 ... I am using weekdays, or day. which create gaps in cross tab since first movie was released on 1st and second was on 11th.
I cannot provide any data I am sorry !
Thank you viz Family !!!
Can Anyone help ???