1 Reply Latest reply: Oct 20, 2015 5:02 PM by Pavan Amin RSS

    Create a Days After chart based on specific x-axis numbers

    Pavan Amin

      Hi

       

      I am trying to create a line chart that shows the number of times a video has been viewed after its initial release date. I have two tables:

       

      Release:

      Vid_Num,

      Release Date

       

      and

       

      View:

      Vid_Num

      View_Date

       

      I left joined the View table to the Release table and did

       

      (View_Date - Release_Date) as Days_After

       

      to get the number of days after Release date. All of this worked perfectly and I was able to graph it using Full Accumulation to show the growth in views, but my issue is I want a specific x axis that shows the release dates as 7, 14, 21, 30, 60, 90, 120, 150, ... 1080 days after release. I was able to show a static 30 day interval by changing the static min, max and step, but i want to add 7, 14, and 21 as well.

       

      Thanks!