Solved

Count max(date)

Posted on 2009-07-16
5
286 Views
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
0
Comment
Question by:dingir
  • 3
5 Comments
 
LVL 1

Author Comment

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

Expert Comment

by:GuitarRich
ID: 24867811
try changing the max to count
0
 
LVL 1

Author Comment

by:dingir
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

0
 
LVL 1

Author Comment

by:dingir
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.
0
 
LVL 15

Accepted Solution

by:
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

0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now