Pie chart should have a first column of type string

artafon

Hi!

Could you help me please. I'll try to get pie chart report from:

select count(ji.issuenum) as "Qty", os.caller as "User" from jiraissue ji

join os_historystep os on ji.workflow_id = os.entry_id

where ji.project='13000' and os.finish_date > CAST(:From AS date) and os.finish_date < CAST(:To AS date) and os.action_id=5

and os.caller in (select cwdm.lower_child_name from cwd_membership cwdm where parent_id='17511')

group by os.caller

and get error:  Pie chart should have a first column of type string

artafon

Thx, I resolved, fix query:

select os.caller as "User" ,count(ji.issuenum) as "Qty" from jiraissue ji

join os_historystep os on ji.workflow_id = os.entry_id

where ji.project='13000' and os.finish_date > CAST(:From AS date) and os.finish_date < CAST(:To AS date) and os.action_id=5

and os.caller in (select cwdm.lower_child_name from cwd_membership cwdm where parent_id='17511')