1 Reply Latest reply on Mar 26, 2018 4:21 PM by sai nishant reddy bandi

    Cross tab for next 7 days

    sai nishant reddy bandi

      Hi,

       

      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
      1/1/2018A50002000100060001010500100
      11/1/2018B62626666789412540325454
      21/1/2018C7897787845469512796378974

       

      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 !!!