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?
