Attempting to run a report to show responses to assessment
I'm trying to run a report to show the responses to an assessment instance. Everything I've tried is falling short of actually showing the responses to the assessment. Any ideas? Thanks!
Forum Posts
Double Line Graph
We have one table storing original target and total request submitted. I need to show both on same graph on Performance Analytics dashboard and then on Service Portal.Currently graph is designed using double Line graph in excel and we have to repli...
Add colours to a PA time series (column chart)
Hi,I've got a time series displayed as follows:I want the blue bars to be coloured based on the score... so red as the worst and green (or blue) as the best. However, there doesn't seem to be any way of doing this. I also tried to create a target an...
Trend report on all active tickets in a que
I'm trying to build a trend report that shows how many tickets are active with a group week to week. I want the trend to be "state" or "date". I don't want to know how many tickets were created or closed. I just want to know how many tickets are acti...
Custom interactive filters - how can I use these on Performance Analytics widgets?
Hi! I've tried a few suggestions from previous posts on here but nothing seems to work. I'm not too good at scripting but I can get by however I've hit a brick wall now. I have several widgets showing Performance Analytics data using Incident SLA a...
Resolved! Using Database view in the performance analytics not displaying all the table fields in the Show Records in Analytics Hub
I have created a Indicator Source by using Database Views which name as Incident_SLA (Joining Incident and Task SLA). I have created a scorecard widget and display the values in dashboards, When I click on the count of the widget and clicked on "Show...
Resolved! Visualize group hierarchy
Is there a way get a tree-like visualization of all groups and their hierarchy?Or visualize really any type of hierarchy where a record has a reference to a different record on the same table.i.e. Groups A and B all have the parent Group C. Groups J ...
Resolved! How to restore previous indicator scores?
Hi all, I've accidentally overwritten indicator scores with a historical data collection. Those scores were previously collected daily for a couple months, and were used to report on incidents state as of the day of collection. The historical job hav...
Resolved! Issues with Homepage Deprecation tool
Hello everyone, First of all, sorry if this is not the right forum or topics. But there it goes our experience with the Homepage Deprecation tool.First, the documentation is not clear to what will happen.We tried in DEV, then in our test instance, no...
How to create a report on survey results that show average score as well as comments
We have configured one survey to measure customer satisfaction with IT services. The survey has 6 questions: 5 are scored 1-4 and the 6th question is open-ended "comments." I want to produce a report that shows each survey response as a single line-i...
Resolved! Difference between Interactive Filters and Breakdowns
I'm building a dashboard of reports (no PA involved) and need a filter on top for all widgets in the dashboard.I want to understand what is the difference between a breakdown, interactive filter, elements filter, and breakdown source? What does it me...
Resolved! UI Issue - Columns are not aligned to the header in the report.
Hi experts, When I create a report while using List as the report type, the table cells of the data rows are shifted to the right (as shown below). While looking into the HTML structure of the list, I found that it was because the colspan="2" attribu...
How to visualize Mean Time Between Failures MTBF?
Hello PA Community,I am looking to visualize "Average Days Between P1 Incidents" or also known as Mean Time Between Failures for my division. This is not achievable with Standard Reporting and I can't seem to figure out how to do it with Performance ...
Set up interactive filter on UI builder with default value
Hi there. I am trying to add a filter to a group of metrics in UI Builder. However, I want the metrics to default to last 30 days when the filter isn't being used. Is there a way to set up the filter to default to last 30 days? I see an area where...
Interactive filter with multiple references to the same reference table but for diff reference field
I am trying to create an interactive filter for all the managers. We have 4 hierarchy of managers. Based upon the manager selected from the interactive filter, the report should display the list of dashboards created by subordinates. For this, I am f...
