Forum Discussion
Need Help with Summing Values
Anonymous
pls see the attachment below. Hope it's helpful.
still have a question. why the date for expected output is 2020/1/15 and 2020/1/16?
In the Review Time column in the above picture, every row should have a value of 60. but the output I am getting is Review Time = Count Analysis*60. I only want it to show 60*1
Anonymous
maybe you can try distinctcount(analysis)* average(testing leadtime)
Yea still no luck. the only way to exaplain it is this way:
My lead time is the sum of cycle time and review time. if I have 10 samples to test my cycle time will be multiplied by 10. but I review the entire set of 10 samples one time.
so if I have 10 samples, my cycle time is 10, and my review time is 50 then the value of my lead time should be Lead Time = Cycle*#samples + Review Time = (10*10) + 50 = 150 minutes. my review time column contains a lot of different values for Review time based on the specific test in the Analysis column. so averaging, using Min, or Max will not work. any suggestions is appreciated
Anonymous
sry, still not clear about this. Could you pls provide some sample data, not the screenshot and also provide the expected output based on your sample data?
Sample Data:
Date Testing Cycle Time Testing Lead Time Testing Review Time Last Analysis 4/14/2020 20 60 45 AZBR_ID_E_EP_N 4/14/2020 20 60 45 AZBR_ID_E_EP_N 4/14/2020 20 60 45 AZBR_ID_E_EP_N 4/14/2020 20 60 45 AZBR_ID_E_EP_N 4/14/2020 20 60 45 AZBR_ID_E_EP_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N 8/4/2020 10 90 30 AZBR_ID_A_EP_QC9522_N Current Results:
Year Month Day Count of Product2 Testing Cycle Time Testing Lead Time Testing Review Time Total Time Last Analysis 2020 April 14 5 100 300 225 625 AZBR_ID_E_EP_N 2020 August 4 10 100 900 300 1300 AZBR_ID_A_EP_QC9522_N Expected Result:
Year Month Day Count of Product2 Testing Cycle Time Testing Lead Time Testing Review Time Total Time Last Analysis 2020 January 15 5 100 60 45 205 AZBR_ID_E_EP_N 2020 January 16 10 100 90 30 220 AZBR_ID_A_EP_QC9522_N Total Time = SUM(Testing Cycle Time + Testing Lead Time + Testing Review Time)
Let me know if this helps!