Create a Days After chart based on specific x-axis numbers
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:
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.