SSRS group by datediff for Pie chart
<p>I'm just starting learning SSRS so forgive me if this is a simple question but I can't seem to find an appropriate answer... I have a dataset with service tickets, query something like this:</p>

<pre><code>SELECT service_tickets, Company_id, Urgency, Date_Entered_UTC, Date_Closed_UTC
   CASE when servicetype = '' then 'Other' else servicetype end as ServiceType, 
   CASE when servicesubtype = '' then 'Other' else servicesubtype end as ServiceSubType, 
FROM v_Service
WHERE Hours_Actual &gt;0
</code></pre>

<p>I am wanting to group the results of this by quarter using the <code>date_entered</code> field for a Pie chart (and ultimately display it as a percentage of the total i.e. 40% of all tickets logged in Q1, 20% of all tickets logged in Q2 etc but I'll worry about that later). The query below gives me the correct count:</p>

<pre><code>SELECT count(service_tickets) as Tickets 
FROM v_service 
   WHERE ...
GROUP BY DATEDIFF(qq, date_entered, getdate())
</code></pre>

<p>However, as I'm using the dataset for several graphs in the same report I need to keep all the fields as they are in the first query. So I'm trying to figure out how to tell SSRS to group the results from the first dataset to give me the results like from the second query. In essence, how can I translate the <code>group by datediff</code> into a pie chart using the original dataset? </p>