6 Replies Latest reply on Jan 23, 2019 5:39 AM by krishna.amilineni.0

    Filter that can point to different datasources

    krishna.amilineni.0

      Hi All,

       

      I am new to tableau and i am in a situation where my requirement is as explained below:

       

      I have 52 worksheets each sheet for each state in USA.The columns in every sheet are same.

      Can I use these worksheets as separate Datasources in Tableau workbook.

      Can I have a filter which contains list of states and when one state is selected, the dashboard will show that states data.

      Each drop down item(state name) should be getting the data from a single sheet.

       

      Please let me know if this is possible to achieve in tableau.

       

      In order to have a single big Datasource instead of different files for each state, the number of rows are going beyond 200 million rows.

      Kindly comment on this approach aswell.

       

       

      Thanks

      K