Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var table = GetCSTStackedBarChartTable(classId, subjectArea, shortNameRowFilter);
- var query = from row in table.DefaultView.ToTable().AsEnumerable()
- where
- row.Field<string>("ProficiencyLevel") == "Advanced" ||
- row.Field<string>("ProficiencyLevel") == "Proficient"
- group row by row.Field<string>("ShortName") into grouping
- select new Object[]
- {
- grouping.Key,
- grouping.Sum( count => count.Field<int>("ProfCount"))
- };
- decimal total = query.Sum(s => Convert.ToInt32(s[1].ToString()));
- var result = query.Select(s => Decimal.Round(Convert.ToInt32(s[1]) / total, 2));
- return result;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement