1 Reply Latest reply on Aug 6, 2015 5:27 AM by Jenny.Lardh

Query that displays open and closed by week almost a trend report.

jkstillman1 Jul 15, 2015 11:25 AM

Have parts of it just cant figure out how to display it by grouping weeks together M-Sun

Granted all I have thus far is the closed but i get my results however I want to set priamiters to allow to sort by week meaning using mon-sun as my week and there being 52 weeks a year

query.JPG 27.5 K

1. Re: Query that displays open and closed by week almost a trend report.

Jenny.Lardh Aug 6, 2015 5:27 AM (in response to jkstillman1)

Hi,

You can group your query by week in Console if you go to your Group page when you modify your query. Drag out "Creation Date" and then set your Range to Weekly.
Note that this will display with weekly groups in Console only. In Web Desk the Range option hasn't yet been implemented.

Kind Regards,
Jenny
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions

Legend

Correct Answers - 20 points