Hi,
I have three table that related to ServiceDesk Plus like below details:
Table 1: worklog
Table 2: task
Now I want to generate this result with Analytics Plus that every count of table is independent. What should I do?
These table have relationship to each other. When we use summarize option to generate this table, count task related to count of request and count of worklog related to task. I don't want to generate report that these count related to each other.
I use this query for generate report that needs but I want to generate report by visual drag and drop feature in Analytics Plus:
select "Technician", sum(is_workid), sum(is_taskid), sum(is_requestid)
from ((select "Technician", 1 as is_workid, 0 as is_taskid, 0 as is_requestid
from "WorkLog"
) union all
(select "Owner", 0, 1, 0
from "Tasks"
) union all
(select "Technician", 0, 0, 1
from "Request"
)
) t
group by "Technician";
version: Analytics Plus v4700
Do you have any solution?
Thanks for helping