1 Reply Latest reply on Sep 17, 2018 9:38 AM by Deepak Rai

    linked two data sets but two measures from secondary data set are not showing proper numbers when filtering

    a m

      Hi everyone

       

      I am trying to blend two data sets to create a text table. Unfortunately I ran into a little  issue two measures are only showing the total sums

       

       

      Primary data set

       

       

      teamtransitLTD status employee hours
      A100LTD1.00
      B2001.00
      C500LTD0.50

       

       

      Secondary data

       

      TeamtransitPlan APlan B
      A100105
      A2002010
      A50055

                                                                                      total           35                                    20

       

       

       

      When I make the text table that contains data from both the data sets where I want the user to be able to filter through the Team and transit but the Plan A and Plan B shows the total amount not the individual number for the transit. I want this outcome for another sheet but for this I want it to show the individual transit

       

      Tableau final Text Table

       

      what happens which I don't want for this sheet

       

      teamtransitLTD count employee hours sumPlan APlan BVariance
      A10011.00352015

       

       

      what I want and the user can filter through team and transit

       

      teamtransitLTD count employee hours sumPlan APlan BVariance
      A10011.001055

       

       

      On another sheet I will display the totals for Plan A and Plan B

       

       

      How can I make the above result happen?

       

      can this be done by blending the data? or do I have to join the data to make this happen? these two tables will be put on a dashboard with a text table that uses only  data from the primary data set and then I want to have it all linked to certain filters.

       

       

      thanks