Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I was able to get it to work by adding
=ValueList(7,14,21,30,60,90,120,150,180,210,240,270,300,330,360,390,420,450,480,510,540,570,600,630,660,690,720,750,780,810,840,870,900,930,960,990,1020,1050,1080)
in the dimension. It works for now but if anyone has a better solution, please let me know. The expression is changed to embedded if statements. I attached the new graph.
Thanks!