Count max(date)

Posted on 2009-07-16
Last Modified: 2013-11-11
Need help with a linq query

                var bpa = from ga in dbg.Stats
                          where ga.UId == usr
                            && ga.Date >= dBegin && ga.Date < dEnd
                          group ga by new { ga.Date.Day } into gr
                          select new
                              name = gr.Key.Day,
                              value = gr.Max(z => z.Date)

But "value" gets a date, the "value" should contain the total count of hits with that date.

Thank's in advanced
Question by:dingir
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Author Comment

ID: 24867801
Rising pooints because it's important.
LVL 12

Expert Comment

ID: 24867811
try changing the max to count

Author Comment

ID: 24867922
Thank's but i need to take the latest date for each result.

the table looks like
Date               UId
2009-01-01    10
2009-01-05    10
2009-01-04    10
2009-01-01    8
2009-01-01    10
2009-01-04    7
2009-01-02    4
2009-01-03    9

I need a query that takes all 2009-01-05 and count those results.
Which means result:
topdate count
2009-01-01 3
2009-01-02 1
2009-01-03 1
2009-01-04 2
2009-01-05 1


Author Comment

ID: 24868243
Whatever and however I describe it. I need a query like this (this is a new another school sample taken from web)

   var categories =
      from p in products
      group p by p.Category into g
      select new {
           Category = g.Key,
           MostExpensivePrice = g.Max(p => p.UnitPrice)

...that returns the count of existing "g.Max(p => p.UnitPrice)". Not the latest date itself.
LVL 15

Accepted Solution

jinal earned 450 total points
ID: 24870147

var bpa = from ga in dbg.Stats
                          where ga.UId == usr
                            && ga.Date >= dBegin && ga.Date < dEnd
                          group ga by new { ga.Date.Day } into gr
                          select new
                              name = gr.Key.Day,
                              value = gr.Count()

Open in new window


Featured Post

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question