Dashboard: Object modification

[ShlomoKatz]

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.

[JamiePryer]

Hey!

good question - can you share some screen shots, just so i can test my end too, please

[DocFrank · Accepted solution]

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

[ShlomoKatz]

Thank you!

I had to add :

group By department

[h.mandle]

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.

[ShlomoKatz]

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