StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This will give you a starting point - You can use a Totals query if you don't want to delve into the SQL itself</p> <pre><code>SELECT CSO,Service,Count(Feedback) FROM MyData WHERE FeedbackDate between DateStart and DateEnd AND CSO=[CsoName] GROUP BY CSO,Service; </code></pre> <p>I would recommend looking into learning the SQL, even if its simply for the case that it may be quicker to type than to drag and drop on the query builder </p> <p><em>Side note: Its been so long since I used the query builder, I had to write the SQL first, and see what buttons got activated when I changed the view</em></p> <p>the SQL Explained:</p> <p><code>SELECT CSO,Service,Count(Feedback)</code> - What do you want to return. In this case, the CSO, the service and a count of the feedback. How it decides what feedback to count comes later in the SQL<br> <code>FROM MyData</code> - What table (or query) we want to get the info from<br> <code>WHERE FeedbackDate between DateStart and DateEnd AND CSO=[CsoName]</code> - How we want to select the data<br> <code>GROUP BY CSO,Service;</code> this is how the Count is decided - in this case, we group all the CSOs and Services together, and then count the number of feedbacks found for each group.</p> <p>first the query will get a list of all the CSO,Service, and Feedback, based on the restriction we have of the date range and which CSO we are interested in.<br> Then it will put all the CSOs and Services that are the same, and count the number of feedbacks it finds.<br> Finally, it will give you this list back, so you will end up with something like:</p> <pre><code>CSO Service CountOfFeedback FRED Open account 11 FRED Close Account 2 FRED Send Order 47 </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload