I am encountering an issue regarding KPI produced in Dashboard pages.
I create my dashboards from the results of my personalized searches from "All open requests" link
I did my personalized search I got a list of information, then I selected add to dashboard.
Once I have created my dashboard I can check the code of the query which is exactly what I need.
For example:
Open Requests by Subcategories of Services for all the organization
SELECT UserRequest FROM UserRequest AS UserRequest JOIN Organization AS Organization ON UserRequest.org_id = Organization.id JOIN Organization AS Organization1 ON Organization.parent_id BELOW Organization1.id WHERE ((Organization1.id IN ('38', '39', '40', '41', '1', '42', '43', '44', '45', '12', '46', '48', '49', '50', '51', '52', '53', '54', '47', '55', '56', '57', '58', '59', '60', '61', '71', '62', '73', '63', '64', '65', '66', '72', '67', '68', '69', '70')) AND (UserRequest.status IN ('approved', 'assigned', 'escalated_tto', 'escalated_ttr', 'new', 'pending', 'rejected', 'waiting_for_approval')))
I got a result of 77 Requests but I have only an overall of 50 real requests and only 37 when I unselect Resolved and Closed as it was filled in the request below.
Someone has already encountered such problems? I don't understand why everything turn wrong !
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you select a parent and a child organization... you will have twice the number of requests for instance... So if you want information per business units you have to unselect the parent organization...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all,
I am encountering an issue regarding KPI produced in Dashboard pages.
I create my dashboards from the results of my personalized searches from "All open requests" link
I did my personalized search I got a list of information, then I selected add to dashboard.
Once I have created my dashboard I can check the code of the query which is exactly what I need.
For example:
Open Requests by Subcategories of Services for all the organization
SELECT UserRequest FROM UserRequest AS UserRequest JOIN Organization AS Organization ON UserRequest.org_id = Organization.id JOIN Organization AS Organization1 ON Organization.parent_id BELOW Organization1.id WHERE ((
Organization1.idIN ('38', '39', '40', '41', '1', '42', '43', '44', '45', '12', '46', '48', '49', '50', '51', '52', '53', '54', '47', '55', '56', '57', '58', '59', '60', '61', '71', '62', '73', '63', '64', '65', '66', '72', '67', '68', '69', '70')) AND (UserRequest.statusIN ('approved', 'assigned', 'escalated_tto', 'escalated_ttr', 'new', 'pending', 'rejected', 'waiting_for_approval')))I got a result of 77 Requests but I have only an overall of 50 real requests and only 37 when I unselect Resolved and Closed as it was filled in the request below.
Someone has already encountered such problems? I don't understand why everything turn wrong !
Quick resolution for all...
Good to know!
If you select a parent and a child organization... you will have twice the number of requests for instance... So if you want information per business units you have to unselect the parent organization...