Average Flow3Hrs comes as a field? Oh so then left join is not needed. Can you explain how you are getting 50, 500, 400 for the same field (Flow3 Hrs per) in a single row? A single row can have only one of the three values, right? Either 50 or 500 or 400... what is the logic for having different numbers for them?
FROM [lib://APtiv documnets/Complexity_Mix_2.xlsx] (ooxml, embedded labels, header is 1 lines, table is Model);
let vDATA_COUNT = NoOfRows('Project1'); Let vProductlines=Peek('Product Line',Project1,$(n)); let vcomplexity=Peek('Complexity Level',Project1,$(n)); Let vDurationMonthFlow3=Peek("Duration (Month)",,Project1,$(n)); let vImpactmonthFlow3=Peek('Impact month',Project1,$(n));
For n= 1 to $(vDATA_COUNT)-1 // Should read all the rows of the table . Is it correct ?
For i=1 to 36 // Need Total months as 36
For x=1 to $(vDurationMonthFlow3) // Should read through all record values of ("Duration (Month)"
if $(i) =1 then
test: load $(i) as Month, $(x) as Month2, $(vFlow3Impact_Month) as value // Should read all record values of 'Impact month' AutoGenerate 1;
ELSE test: load $(i) as Month, $(x)+($(i)-1) as Month2, $(vFlow3Impact_Month) as value // Should read all record values of 'Impact month'
AutoGenerate 1; ENDIF
Next i ;
This code is perfect to my requirements . Its just That it needs some correction specially For Loop
Finally I need only Value and Month2 to draw my Line curve .