Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

Count max(date)

Posted on 2009-07-16
Medium Priority
294 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
Question by:dingir
[X]
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
5 Comments

LVL 1

Author Comment

ID: 24867801
Rising pooints because it's important.
0

LVL 12

Expert Comment

ID: 24867811
try changing the max to count
0

LVL 1

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

0

LVL 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.
0

LVL 15

Accepted Solution

jinal earned 1800 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()
};
``````
0

Featured Post

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)…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses
Course of the Month6 days, 11 hours left to enroll

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

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