Week function

[geight]

Can you demonstrate how to use the week function in impromtu
for example, how to break down the total count of auto accident in a year to show the count on a weekly basis?
Thanks

 

[nagrajm]

Create 3 columns

YEAR
WEEK
COUNT OF ACCICDENTS

YEAR = year(DATE)
WEEK = week(DATE)
COUNT OF ACCIDENTS = count(Rows)

Group the report on YEAR, WEEK. The count will be associated to the week.

There you go....