Have built a Dashboard in tableau 9.2. with Multi source. There are two sources sql server and my sql where dashboard is referring the data from.
Requirement is to have the graphs to show trend based on week selected on the top. Today minus 12 weeks of trend based on the fiscal week selected.
For example : if Week 34 is selected in the Week filter the graph should display numbers from Week 34 to week 22. Week 34 minus 12 weeks.
Please share ideas on how to achieve this in tableau 9.2.
A few things Sandeep,
1) to show a trend, the date field needs to be continuous (green) pill rather than discrete so that needs to be changed
2) the bars are stacked - and trend lines will not work with stack marks enabled. Do you need that to be on?
Do you have a workbook sharing a small amount of sample data to show what you have working now?
Patrick
Become a Viz Whiz on the Forums! Support the Community and master Tableau.