Need help on creating a chart

[Anonymous]

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

[swuehl · Accepted solution]

Use as calculated dimension

=Aggr( Date(Min(Received_Time)), [Lot #])

and as expression

=Median([Price])

[Anonymous]

THANK YOU, this works perfect!!