I already combined two table using join. But now i want to transform my data as below. Please help. Thanks.
a) Create new line item for each task with created status
b) Create new field "Month_Graph." & assign "Task Created" as its date.
I almost done. But i cannot add this expression. Please advise. Thanks.
Do you have any advise? Thanks.
When you use sum() or count(), you need to add group by!
.... as Total
group by Temp, month_created, [PSR No];
Thanks Fei Xu.
'created' as status,
task_created as month_graph
task_modified as month_graph
Retrieving data ...