4 Replies Latest reply on Oct 15, 2019 2:29 PM by Bryce Larsen

    Difference between first and last measurement

    Tomas Prucha

      Hi,

      I have a table with measurements. Sample of the table looks like this:

       

      IDDMCTimeValue
      1110:10:101,123
      2110:10:140,835
      3210:10:170,666
      4310:10:220,115
      5310:10:260,444
      6410:10:300
      7410:10:350
      8410:10:380,999
      9510:10:420,555
      10610:10:450,963
      11610:10:501,258
      12710:10:541,202
      13710:10:571,581
      14810:11:010,777
      15710:11:051,075
      16710:11:091,024
      17910:11:130,852
      181010:11:170,414
      191110:11:211,369
      201110:11:251,654

      I would like to visualize difference of values between first and last measurement of each part (DMC). Calculation of difference is: Value of min Time - Value of max Time for each DMC separately. So positive, negative and zero results are possible.

      For this specific table desired graph should look like this:

      Because it represents calculated table like this:

        

      IDDMCTimeDifference
      1110:10:140,288
      2210:10:170
      3310:10:26-0,329
      4410:10:38-0,999
      5510:10:420
      6610:10:50-0,295
      7810:11:010
      8710:11:090,178
      9910:11:130
      101010:11:170
      111110:11:250,285

       

      I have tried different attitudes to solve this problem but result is always same. I still get only zeros and I am out of any other ideas.

      Attached Excel file contains only already shown tables and graph.

      Thanks in advance for your suggestions how to get desired output in Tableau 2018.3.3.