Solved

Count max(date)

Posted on 2009-07-16
5
289 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to prevent website from publishing with errors 9 53
start a process from a service 3 30
Convert datetime to time string 10 28
JSON Deserialize issue 6 26
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…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

790 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