Hello
I am trying to utilize dashboards to analyze the business.
Example: System Chart: Users By Department
However, "users by department" includes terminated users that are now part of a defunct department.
So the dashboard shows more departments than there really are.
Other dashboards, such as system information has 7 days - I want to change to 3.
The ask is: Can these dashboards be modified to the customers needs? Example: "User by department" does not include terminated users.
Hey!
good question - can you share some screen shots, just so i can test my end too, please
Hi,
the System components can't be changed/should not be changed. You can however define your own graph that visualizes that data. in your case, the SQL could look something like
(select department, count(1) as users_per_department from avuser.pv_users where is_terminated='False' group by department)
Frank
Thank you!
I had to add :
group By department
Yes, you can define your own custom dashboard. You can also define a jsp page and call it on dashboard. As suggested by Frank, you can define SQL query and then group by your criterion.
Thank you- I followed Frank's advice and created my own.
I have limited knowledge on JSPs, let alone how to implement in G&L
Hi,
the System components can't be changed/should not be changed. You can however define your own graph that visualizes that data. in your case, the SQL could look something like
Frank