Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.88 KB | None | 0 0
  1.             var table = GetCSTStackedBarChartTable(classId, subjectArea, shortNameRowFilter);
  2.             var query = from row in table.DefaultView.ToTable().AsEnumerable()
  3.                         where
  4.                             row.Field<string>("ProficiencyLevel") == "Advanced" ||
  5.                             row.Field<string>("ProficiencyLevel") == "Proficient"
  6.                         group row by row.Field<string>("ShortName") into grouping
  7.                         select new Object[]
  8.                             {
  9.                                 grouping.Key,
  10.                                 grouping.Sum( count => count.Field<int>("ProfCount"))
  11.                             };
  12.             decimal total = query.Sum(s => Convert.ToInt32(s[1].ToString()));
  13.             var result = query.Select(s => Decimal.Round(Convert.ToInt32(s[1]) / total, 2));
  14.  
  15.             return result;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement