User Profile
cbruhn42
Helper III
Joined 7 years ago
User Widgets
Contributions
Re: Averaging Data Taken Within X Minutes
Can you think of a way I could compare the row SampleDateTime to the previous row SampleDateTime and then use that difference to group the samples? For example, I'd just group samples that are within 30 minutes of each other and have more than 2 samples in the grouping.Re: Averaging Data Taken Within X Minutes
It's very close to working. So as long as my data subsets have a change in merged runID it works great. But for example if I run back to back subsets under the same Merged RunID it groups the two subsets together as one. So instead of a set of 4 samples I get a set of 8. Here is an example: The highlighted rows should average and the next 3 rows should average together. I know this by looking at the date/time stamps. You can see how they are grouped closely together. Oh so close!Re: Averaging Data Taken Within X Minutes
HEre is some sample data. SampleID SampleDateTime Comment1_ValveNumber Attribute Value Merged RunID Packaging Line Attribute Average 153243 12/18/2024 18:11 9 TPO2 36 4695 Canning 153244 12/18/2024 18:14 10 TPO2 47 4695 Canning 153245 12/18/2024 18:18 11 TPO2 42 4695 Canning 41.66666667 153116 12/18/2024 20:35 1 TPO2 40 10561 Bottling 153117 12/18/2024 20:39 2 TPO2 34 10561 Bottling 153118 12/18/2024 20:42 3 TPO2 31 10561 Bottling 153119 12/18/2024 20:45 4 TPO2 40 10561 Bottling 36.25 153250 12/18/2024 21:15 13 TPO2 57 4695 Canning 153251 12/18/2024 21:19 14 TPO2 53 4695 Canning 153252 12/18/2024 21:22 15 TPO2 51 4695 Canning 153253 12/18/2024 21:26 16 TPO2 38 4695 Canning 49.75 153120 12/18/2024 21:35 5 TPO2 32 10561 Bottling 153121 12/18/2024 21:39 6 TPO2 27 10561 Bottling 153122 12/18/2024 21:43 7 TPO2 29 10561 Bottling 153123 12/18/2024 21:46 8 TPO2 38 10561 Bottling 31.5 153254 12/18/2024 22:35 17 TPO2 68 4695 Canning 153255 12/18/2024 22:38 18 TPO2 63 4695 Canning 153256 12/18/2024 22:42 19 TPO2 61 4695 Canning 153257 12/18/2024 22:51 20 TPO2 63 4695 Canning 63.75 153124 12/18/2024 22:55 9 TPO2 9 10561 Bottling 153125 12/18/2024 22:58 10 TPO2 43 10561 Bottling 153126 12/18/2024 23:12 11 TPO2 47 10561 Bottling 153127 12/18/2024 23:15 12 TPO2 40 10561 Bottling 34.75 153258 12/18/2024 23:51 21 TPO2 63 4695 Canning 153259 12/18/2024 23:54 22 TPO2 48 4695 Canning 153260 12/18/2024 23:57 23 TPO2 42 4695 Canning 153261 12/19/2024 0:01 24 TPO2 49 4695 Canning 50.5 You can see we switch between packaging runID's / packaging line within our data set. The first set only had 3 samples to it, but the rest have 4. The last column on the right is the average of the values for the attribute TPO2. I need to calculate basedon the attribute because there are about 9 other attributes I'd want to calculate the average for.Averaging Data Taken Within X Minutes
I have a table that has the following columns: SampleID - Date/Time - Attribute - Value - Brand - RunID We take samples in groups of 4. I'd like to find the average of the values in each group of 4. Sometimes if a test fails, we end up with a group of 2 or 3. In these instances I'd like to only calculate the average if we have a minimum of 3 data points. SampleID is a consecutive number for each test. RunID is the packaging run unique ID. Any ideas?
