1 Reply Latest reply on Aug 3, 2018 12:47 PM by Don Wise

    Calculating a ratio

    crhoades

      Hey guys,

       

      I've got a data set that shows the number of orders across specific days, cities, states, and hour numbers (1-24). I need to return a number that is showing (average orders/hour)/(max orders within an hour) for each state. Example of the numbers I am wanting is shown below, where RATIO is the end result I am wanting. The MAX HOUR column is returning the maximum sum of orders within a specific hour. So MO's highest order within an hour was 502, and so on.  Attached is the Tableau workbook with the specific data loaded into it. Please reply if you have any further questions.