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



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