Pie chart via. a task report

Hi

I am currently working on version 17.3.
I have created a task report and the data of this task report is being displayed on a Tempo report in a grid.
I have a column "Status" in this report for which I have an array of values:
0; 0; 0; 0; 0; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2; 2

On the similar lines I want to depict the report data via. a pie chart.
I want to having a grouping based on the "Status" but when I make use of aggregation in a!query(); I get the output "No Records Found".
Also the tasks with status 0 i.e. Assigned is also not getting displayed in the pie chart if I ignore grouping and want to display the entire data set.
Below is the code snippet for the same:

load(
local!selectedStatus,
local!chartPagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1,
sort:a!sortInfo(
field:"c1",
ascending:true
)
),
with(

local!chartDatasubset:a!queryProcessAnalytics(
report: cons!PH_DAILY_TASK_REPORT,
contextProcessModels: cons!PH_MODEL_FOR_DAILY_TASK_REPORT,
query: a!query(

pagingInfo: local!chartPagingInfo
)
),
{
if(
local!chartDatasubset.totalCount = 0,
a!textField(
value: "No records found",
readOnly: "TRUE"
),
{
a!textField(
value:local!chartDatasubset.data.c1,
readOnly:true
),
a!pieChartField(
series: a!forEach(
items: local!chartDatasubset.data,
expression: a!chartSeries(
label: fv!item.c1,
data: fv!item.c1,
links: a!dynamicLink(value: fv!item.c1, saveInto: local!selectedStatus)
)
)
)
}
)
}
)
)

Thanx in advance!!