2 Replies Latest reply on Nov 8, 2016 1:38 AM by Pruet Kritiyapichatkul

    How to do a ratio calculation

    Pruet Kritiyapichatkul

      Hi,

       

      I am new to Tableau and just start studying it. I hope this forum can help me progress my learning.

      Currently, I am doing a stat analysis of this data in the table below. I would like to create a case created / completed ratio per month.

      Can someone guide me how I can do that, please?

       

      Thank you,

      Pruet

         

      Case IDCreatedCompleted
      ABC-2218331/08/2016 14:2501/09/2016 16:18
      ABC-2217631/08/2016 10:1431/08/2016 20:59
      ABC-2214525/08/2016 12:2529/08/2016 16:05
      ABC-2171420/07/2016 17:2025/07/2016 14:56
      ABC-2171220/07/2016 16:2422/07/2016 12:10
      ABC-2170520/07/2016 12:5421/07/2016 16:54
      ABC-2138922/06/2016 18:3412/07/2016 11:26
      ABC-2137922/06/2016 11:1227/07/2016 16:36
      ABC-2137722/06/2016 07:4708/08/2016 01:48
      ABC-2137622/06/2016 07:3622/06/2016 16:14
      ABC-2137522/06/2016 07:3322/06/2016 11:22
      ABC-2096917/05/2016 23:3323/05/2016 10:13
      ABC-2096717/05/2016 14:4922/06/2016 10:17
      ABC-2096617/05/2016 14:0918/05/2016 17:51
      ABC-2096517/05/2016 13:4518/07/2016 15:57
      ABC-2096417/05/2016 12:2821/06/2016 07:34
      ABC-2096317/05/2016 11:3923/05/2016 17:56
      ABC-2097317/05/2016 10:0918/05/2016 15:56
      ABC-2095716/05/2016 18:1616/05/2016 19:51