Query of Query?

DreamCoder

I was wondering if anyone knew a way to do a query of a result set? For example, I have a dataset called DS_agentTotals, and I want to run a query against the result set it produces, kinda like this:

SELECT
agent_name,
SUM(calls) AS total_calls
FROM DS_agentTotals
GROUP BY agent_name

Is this possible? Is there a possible workaround or different way of approaching it? Any ideas would be great!

Thanks,
Amanda

mwilliams

Hi Amanda,

You can put a table in your report linked to your dataSet, group it on agent_name, and add an aggregation that sums the calls over the group to the group footer. This should do what you're wanting. Let me know if you have questions.