private void LoadPeriodGraphData(PMIOperation pmiOperation, string operationNumber) { //render second graphic var rawData = _clientPMIDetails .GetValuePerformance(0, operationNumber, pmiOperation) .OrderBy(c => c.Year); var transformed = new { Actual = rawData.Select(c => new object[] { c.Year, c.Actual == -1 ? null : (decimal?)c.Actual }), Planned = rawData.Select(c => new object[] { c.Year, c.Planned == -1 ? null : (decimal?)c.Planned }), Earned = rawData.Select(c => new object[] { c.Year, c.Earned == -1 ? null : (decimal?)c.Earned }), AnnualPlanned = rawData.Select(c => new object[] { c.Year, c.AnnualPlanned == -1 ? null : (decimal?)c.AnnualPlanned }), AnnualEarned = rawData.Select(c => new object[] { c.Year, c.AnnualEarned == -1 ? null : (decimal?)c.AnnualEarned }), Raw = rawData, Years = rawData.Select(c => c.Year).Distinct().OrderBy(c => c) }; ViewBag.PeriodGraphData = transformed; }