Forum Discussion
Comparing years in line graph
Super UserI understand. To use my sample code follow the below steps.
Go to Transform data.
Right click in a blank area in the query pane and select New Query --> Blank Query
With the query selected, choose Advanced Editor
Paste my code over what is there and click done.
You'll then be able to see the steps I followed.
Essentially, all you're trying to do is add a column for year for the legend and one for a date part of some kind that excludes year (I used week number) for the X axis.
What you end up with is...
Thanks so much!
I did this on my table and it created the new queries and i see them, but they have no effect on my table right now. I tried creating relationships between the date and my tables, but it doesn't do anything. Do I have to customize your code to fit with my tables and correct column names that I'm pulling from my server? I'm using several different sections of a server to bring information together.