13 Replies Latest reply on Aug 5, 2016 6:12 AM by Andrew Watson

    Any ideas on how to make a rate with this set of data?

    Aaron Lum

      Attached is a set of data that I want to make a chart with. The chart will represent a rate which will be:

       

           Sum of count

      ________________

       

      (Total Hours/month)

       

      So for example A would have a count of 6 over 13 hours in the month of January and a count of 4 over 11 hours in the Month of February.

       

      I don't know what the best way to do this would be in Tableau, does anyone have any ideas?.

      I should note that I also can't do this in Excel because the attached chart is just a sample representation of a much larger dataset I'm working with stored on an Oracle server.