1 Reply Latest reply on Feb 23, 2017 9:51 AM by Patrick Van Der Hyde

Need Help to Build Dynamic Filter with Multi Source

sandeep.a.0 Feb 13, 2017 12:51 PM

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.

1. Re: Need Help to Build Dynamic Filter with Multi Source

Patrick Van Der Hyde Feb 23, 2017 9:51 AM (in response to sandeep.a.0)

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
Like Show 0 Likes(0)

Actions

Tableau Community Forums