How to MULTIPLE Dates from comboBox/list to plot on dynamic generated chart?

[axf5027]

Hello All,

I have a very large data file(400,000 rows x 10 columns) comprised of Software Load Tests from several different test runs on different dates. The data contains memory usage and cpu usage values among other things, collected at 1 second intervals from several different processes. I have created a mock data sample.


I want to be able to select(Possibly from a comboBox?) which dates(multiple) I want to plot of CPU vs. Time for each of the different Program-Processes overlayed on the same chart. I would like it to be a line chart, with each line representing a different Program-Process. I am trying to have the chart auto-generated after selecting which date's data I would like to view on the chart.

I have all the data organized in a Table as well as a Pivot Table.

The request seems very simple now that I typed it out, but I can't find a possible solution anywhere. Thanks in advance.

-A


Process ID Process Name Date Time CPU Usage% Mem Usage
11111 PROCESS 1 1/1/16 1:00 2 245
11111 PROCESS 1 1/1/16 2:00 0 245
11111 PROCESS 1 1/1/16 3:00 0 245
11111 PROCESS 1 1/1/16 4:00 1 245
11111 PROCESS 1 1/1/16 5:00 3 267
11111 PROCESS 1 1/1/16 6:00 3 267
11111 PROCESS 1 1/1/16 7:00 0 278
11111 PROCESS 1 1/1/16 8:00 0 289
11111 PROCESS 1 1/1/16 9:00 2 300
11111 PROCESS 1 1/1/16 10:00 1 311
22222 PROCESS 2 1/1/16 1:00 0 80
22222 PROCESS 2 1/1/16 2:00 0 80
22222 PROCESS 2 1/1/16 3:00 0 80
22222 PROCESS 2 1/1/16 4:00 0 80
22222 PROCESS 2 1/1/16 5:00 0 80
22222 PROCESS 2 1/1/16 6:00 5 80
22222 PROCESS 2 1/1/16 7:00 0 80
22222 PROCESS 2 1/1/16 8:00 0 80
22222 PROCESS 2 1/1/16 9:00 1 80
22222 PROCESS 2 1/1/16 10:00 0 80
33333 PROCESS 3 1/1/16 1:00 1 80
33333 PROCESS 3 1/1/16 2:00 1 81
33333 PROCESS 3 1/1/16 3:00 1 83
33333 PROCESS 3 1/1/16 4:00 0 85
33333 PROCESS 3 1/1/16 5:00 4 87
33333 PROCESS 3 1/1/16 6:00 4 89
33333 PROCESS 3 1/1/16 7:00 4 91
33333 PROCESS 3 1/1/16 8:00 3 93
33333 PROCESS 3 1/1/16 9:00 2 95
33333 PROCESS 3 1/1/16 10:00 1 97
21212 PROCESS 1 1/8/16 1:00 0 900
21212 PROCESS 1 1/8/16 2:00 2 900
21212 PROCESS 1 1/8/16 3:00 2 900
21212 PROCESS 1 1/8/16 4:00 2 900
21212 PROCESS 1 1/8/16 5:00 5 900
21212 PROCESS 1 1/8/16 6:00 4 900
21212 PROCESS 1 1/8/16 7:00 4 900
21212 PROCESS 1 1/8/16 8:00 5 900
21212 PROCESS 1 1/8/16 9:00 2 900
21212 PROCESS 1 1/8/16 10:00 1 900
31314 PROCESS 2 1/8/16 1:00 1 78
31314 PROCESS 2 1/8/16 2:00 1 81
31314 PROCESS 2 1/8/16 3:00 1 84
31314 PROCESS 2 1/8/16 4:00 2 87
31314 PROCESS 2 1/8/16 5:00 2 90
31314 PROCESS 2 1/8/16 6:00 5 93
31314 PROCESS 2 1/8/16 7:00 4 96
31314 PROCESS 2 1/8/16 8:00 2 99
31314 PROCESS 2 1/8/16 9:00 1 102
31314 PROCESS 2 1/8/16 10:00 1 105
54312 PROCESS 3 1/8/16 1:00 32 50
54312 PROCESS 3 1/8/16 2:00 1 52
54312 PROCESS 3 1/8/16 3:00 1 52
54312 PROCESS 3 1/8/16 4:00 2 52
54312 PROCESS 3 1/8/16 5:00 2 54
54312 PROCESS 3 1/8/16 6:00 5 54
54312 PROCESS 3 1/8/16 7:00 8 55
54312 PROCESS 3 1/8/16 8:00 8 55
54312 PROCESS 3 1/8/16 9:00 2 56
54312 PROCESS 3 1/8/16 10:00 8 57

[axf5027]

ScreenShot of Sample Data Capture.JPG