I have created a database view for joining Requests,RITMs,SCTasks and Approvals. I have used left join for sctask and approver tables while defining in the DB view. Now the issue is in the list it is showing duplicate records for the sctasks, a singl...
Hi Team , we have 1 demand and every demand we have assigned to 1 Project and 1 project we have several Project task . Can t we have in one line all task front of related project? I mean its leading to more then one column .do we have any solution ...
Hi all, I'm trying to build a visualization in Platform Analytics for a specific purpose, I think I'm missing out on a step but would love any insight anyone can offer. In summary, I've exposed the cost centre field on the assignment group. Every Inc...
Hi Team, I am unable to produce all data in analytic hub How do i show all the records
Hi,I have a couple of questions regarding the migration process from Core UI to Platform Analytics:Standalone Reports: Will reports that are not currently used in any dashboards (i.e., standalone reports) be included in the migration process? If not,...
Hi Everyone, I want to fetch total number of days in each month using an automated indicator.Example : January - 31Feb - 29March - 31
Hi, friends. I've been scratching my head on how to achieve this in Performance Analytics:I need a breakdown by Group Type in ServiceNow. My indicator is a tag (in the label_entry table), which is assigned to certain incident records by a user.Essent...
Hi Everyone, I am looking for help to create dashboard widget with combination of multiple table(data source) and some certain query to filter out the data like Risk Score = (Incident Count × 1.5) + (Critical Alerts × 2.0) + ((100 - Availability %) ×...
Hello, I have a new dashboard in Platform Analytics. I shared it with a team for read view, and at the same time with one member of this team, in a Write view. Which right will be applied: Read or Write? Best regards
I am looking for help creating a report on Parent changes that shows related child changes and related incident records. I attempted this with a DB view combining the tables but its confusing and doesn't seem to provide all the data as expected. Does...
Hi - I have created an automated indicator that pulls the records from SLA Breakdown by Assignment group table to measure the Incident SLAs for my supplier. This table has records for all the assignment groups but the breached column is set based on ...
As part of a dashboard data visualization element, I would like to plot the average of the difference between two fields in a record (i.e. `AVG(table.fieldB - table.fieldA)`) but have struggled to find something that doesn't seem overly complicated f...
Hey Team, New Dashboard was created. 1st Version was captured with 2 Visualizations True and False. (English) Saved and Exit editing mode. Confirmed in Spanish (or preferred Language) and Visualization appear in Spanish 2nd Version add a Simple Li...
Hi Team, I have a requirement to fetch the application availability for Criticality 1,2,3 applications. We need reports to show availability in percentage and in Mins. I have created indicators and breakdowns accordingly based on data in cmdb_ci_outa...
In the Request Management Overview dashboard, there is a widget called Mean time to fulfill a requested item (by category) I need to know:Which Automated Indicator is used for this widget?Which data collection job runs to populate this indicator?How ...
