2 Replies Latest reply: Jun 17, 2016 5:50 PM by Yolanda Wei RSS

    Need help on creating a chart

    Yolanda Wei

      Hello,

       

      I am trying to create a chart in QV with "Min_Received_Time" as my X-axis, and "Median_Price" as my Y-axis. Can you help me to figure out how I can build this chart?

       

      Here is an example of my raw data table:

      ReceivedTime

      Kit ID

      Lot #

      Price

      6/12/16 19:00

      1

      123-A

      850

      6/12/16 19:03

      2

      123-A

      800

      6/12/16 19:04

      3

      123-A

      900

      6/12/16 19:38

      4

      123-A

      850

      6/13/16 3:44

      5

      650-A

      750

      6/13/16 3:48

      6

      650-A

      825

      6/13/16 3:50

      7

      650-A

      825

      6/13/16 3:51

      8

      650-A

      900

      6/13/16 19:20

      9

      125-A

      900

      6/13/16 19:21

      10

      125-A

      900

      6/13/16 19:23

      11

      125-A

      800

      6/13/16 19:34

      12

      125-A

      900

      6/13/16 19:35

      13

      125-A

      1000

      6/14/16 3:38

      14

      220-A

      1000

      6/14/16 3:39

      15

      220-A

      990

      6/14/16 3:40

      16

      220-A

      1100


      Then, I would like to group by Lot #, and calculate the Minimum Received Time and Median Price for each Lot #, as show in the table below:

      Lot #

      Min_Received_Time

      Median_Price

      123-A

      6/12/16 19:00

      850

      650-A

      6/13/16 3:44

      825

      125-A

      6/13/16 19:20

      900

      220-A

      6/14/16 3:38

      1000


      So, the output I want to have is a chart with Min_Received_Time as my X-axis, and Median_Price as my Y-axis. And the input is the raw data. Can anyone help me to figure out how to do this?


      Thanks in advance!


      Thanks,

      Yolanda