1 Reply Latest reply on Dec 7, 2015 3:02 PM by Diego medrano

    Projected Hours Graph

    Richard Houston

      Hi,

       

      I'm trying translate a capacity/manpower graph from excel into tableau to connect with our source Salesforce data. In the attached excel file I've pulled a couple example rows of our data.

       

      1. Source data
        • Salesforce opportunities
        • Contains the necessary data points to calculate out months of work and hours needed each month
      2. Modified
        • The data from source is transformed to project out number of labor hours per month
        • Dates are projected out through the duration of the projects

       

      Is it possible to create a similar function within tableau? I'm not sure how to transform the source data to project out over months and sum the hours in the crosstab.

       

      I thought that this topic was sort of on the path, but couldn't really get it to work as expected.

       

      Thanks for any help or direction!

       

      Best,

      Richard