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



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