Need to create Time Series dashboard(Line Chart), which must meet following conditions

sayalimore
Kilo Expert

Hi All,

I need to create one separate dashboard for nearly 48 groups. The dashboard must contains 2 tabs with reports 'Incidents open assigned to the group' and 'Incidents open assigned to the users of the group'.

The dashboard will restrict in the following way:

  • Each group member will be able to view the dashboard of their assigned group.
  • Identified users will have access to view all dashboards.

How could I create this in Eureka version?

Thanks in advance,

Sayali

5 REPLIES 5

Paul Rice
ServiceNow Employee
ServiceNow Employee

I think the first report you are looking for uses javascript:getMyGroups() on the assignment group.   That's the easy one.


If I understand the second report, you are looking for all incidents where the callers are members of specific groups.     I have had similar requests but always used the department field on the user record to show incidents by the department.


NOTE: I this will work for Fulfillers Only.   Requesters are limited to only their incidents created by them or for them (Created By, or Caller ID = the logged in user)



I don't recall if Eureka had tabs for dashboards.   You could show them side by side on a single dashboard.


Paul Rice
ServiceNow Employee
ServiceNow Employee

I think looked past your title when wrote my first response.



Time series is going to be more difficult.   You can use a breakdown to show the time line by assignment group.   That works because there is a single assignment group on the incident.     If you are looking for callers from a group that's going to force you to choose a default group.     I do suggest you set up a breakdown based on the callers department value instead.      



Viewers that are not fulfillers will still have an issues seeing any of the detail records.


Need to create a dashboard for nearly 47 groups in which reports to be shown on incident table and all report are same for every group. So, we want to create one dashboard which will be dynamically showing the result based on the login user.

For this, we have created indicator source in which we have mentioned condition Assignment group is dynamically one of my groups.


Accordingly, we have created indicator, breakdowns is Assignment Group on incident table(breakdown source-Groups Active ) and widgets and added it to the dashboard.


Here, the issue we are facing is when we run the job to populate the data in dashboard, it is taking the user whom we specified in "Run as" field and showing the data.


But, we want to show information based on login user


Paul Rice
ServiceNow Employee
ServiceNow Employee

The problem remains the same.   Users can be members of many groups.   How do you picture the dashboard dealing with that?   Once data is broken down, there isn't a way to restrict who get's to see a subset of the buckets.



The indicator source shouldn't use the dynamic filter.   As you say it's only getting you records based on the value in Run As field.     You need to create all the breakdowns by all the groups for the full set of data.



I haven't tried to use ACLs on the scores table.   That might a simple way to reduce the breakdowns a person can see.


Have the ACL only read records when Breakdown is Assignment group and Element is one of my groups.