groupby count and percentage

Question

Is there a simple way to show a percentage of the total within a Linq GroupBy?

I currently have:

private static object GetPageUsers(IEnumerable<Pagehit> getPageLog)
{
    return getPageLog
          .GroupBy(g => g.UserID)
          .Select(x => new { User = GetUserFName(x.Key.ToString()),
                             NumberOfHits = x.Count(),
                             percentage = x.Count() / total
          })
          .OrderByDescending(o => o.NumberOfHits);
}

In this line percentage = x.Count() / total how do I get the total?

Can you tell us what your getPageLog contains? It will be better if you rephrase your question. It is not understandable. — Dhwani, Mar 20 '14 at 10:52
Have you tried `percentage = x.Count() / getPageLog.Count()` *100 + "%" — Marco, Mar 20 '14 at 10:52
Serv, thats exactly what I was looking for. Clearly not had enough coffee today! Thank you — Gordon Copestake, Mar 20 '14 at 10:54

score 1 · Accepted Answer · edited Mar 20 '14 at 11:15

1

getPageLog is an IEnumerable, so it has no Count property. But it should have a Count() extension method.

You could get it using:

private static object GetPageUsers(IEnumerable<Pagehit> getPageLog)
{
    return getPageLog
          .GroupBy(g => g.UserID)
          .Select(x => new { User = GetUserFName(x.Key.ToString()),
                             NumberOfHits = x.Count(),
                             percentage = (100 * x.Count()) / getPageLog.Count() + "%"
          })
          .OrderByDescending(o => o.NumberOfHits);
}

edited Mar 20 '14 at 11:15

Gordon Copestake

1,616
4
21
37

answered Mar 20 '14 at 10:55

Marco

22,856
9
75
124

Is getPageLog better as a `List<>`? – Gordon Copestake Mar 20 '14 at 10:59
That depends on what you are doing. Using a List you are forcing the compiler to execute right away. Using an IEnumerable interface the execution is delayed until it is needed. There are far better explanations than mine around. See here: http://stackoverflow.com/questions/3628425/ienumerable-vs-list-what-to-use-how-do-they-work – Marco Mar 20 '14 at 11:02

groupby count and percentage

1 Answers1