Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Database view in performance analytics

prasad48
Tera Guru

‎06-27-2017 03:15 PM

Hi,

I created view for task and task_sla   and my requirement is show breached tickets count by break down   based on assignment group.

I have added   database view in the indicator and added breakdown as group table   and assignment group column

Here issue is i am not able to filter by assignment group.Please help?

find_real_file.png

Preview file
60 KB
0 Helpfuls
  • 2,572 Views
5 REPLIES 5

sachin_namjoshi
Mega Patron

‎06-27-2017 03:21 PM

What's breakdown source configuration?


Please make sure that "Sys ID" is used as in source.



find_real_file.png




Regards,


Sachin


Preview file
29 KB
0 Helpfuls

prasad48
Tera Guru

‎06-27-2017 03:48 PM

When am using table as indicator source   and breakdown source it is working fine.


But when i use databaseview as indicator source and breakdown source , then it is not working. Is it correct to you database view?


0 Helpfuls

sachin_namjoshi
Mega Patron
In response to prasad48

‎06-27-2017 03:53 PM

You need to create a read ACL for your users on the tables in a view to generate reports on database views. Non-admin users do not have access to database view records unless a read ACL on the database view record allows access.



Regards,


Sachin


0 Helpfuls

Mubashira
Tera Contributor
In response to prasad48

‎06-29-2022 09:06 AM

Hi,

I am getting the same issue. Please let me know if anyone has solution for this issue.

0 Helpfuls