2 Replies Latest reply on Mar 11, 2016 2:29 AM by Samuel Gee

    Blend multiple data sources into one stacked chart

    Samuel Gee

      I have six retailers, each with a sales volume for a product. They have their own Excel flatfiles where all their sales are stored.

       

      In the attached screenshot, all the excel files have been added to tableau. The dimensions have, in the edit relationships field, been linked.

       

      http://i.imgur.com/LvB41qf.png

       

      I'd like one stacked chart, with all retailer volumes shown within. But tableau doesn't recognise these six measures as elements of the same measure. So I can only contrast them to each other, as I have done here.

       

      How do I pull all the content in as facets of the same measure? Do I have to write a SQL query?

       

      Is this the correct route forward: Combining Multiple Data Sources into One View | Tableau Software? I just found it.

       

      Thank you!

       

      Sam

       

      Message was edited by: Samuel Gee