Plotting S-Curve for Earned Value analysis from Primavera tables
(1) We are at the moment querying below fields for the respective data on the 'Project X' tables
ProjectX/SummaryEarnedValueByCost --> Earned Value
ProjectX/SummaryPlannedValueByCost --> Planned Value
ProjectX/SummaryActualTotalCost --> Actual Cost
We understand TASKSUM has bcwp double(22,6) which can provide Earned value data. Which table should ideally be queried for Earned Value(EV),Planned Value(PV) & Actual Cost(AC) : TASKSUM or Project X
(2) How can we get time distributed data for Earned Value(EV),Planned Value(PV), Actual Cost(AC) so we can plot a S-Curve for them over the project duration or how can we spread the cumulative figures available for EV,PV,AC from ProjectX tables or TASKSUM over the duration of project to plot the graph(S-Curve)