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

    Projected Hours Graph

    Richard Houston



      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!