It's sales data. Basically I have sales for the past four years. On one graph I want to compare current sales to the previous years sales. The fields are the same and I can't seem to get the filter to work the way I want it.
It's coming from SQL Server. Now that I'm thinking about it I could just write a query to pull the specific data I need. Sometimes when working with Tableau my thought process get's very narrow
1 of 1 people found this helpful
I faced the same problem. Better way is to write a Custom SQL query and working on it.
That is exactly what I'm looking for, I'm struggling to get that. Any ideas to help me get started with that?
EDIT: I was over complicating things in my head, very simple. Two separate connections using the getdate sql function.
Thanks for your help guys!