Hi There, is there a possibility to measure the time a tickets spends in a specific state? I would like to have an average time tickets of a specific service are on hold or work in progress. How would I do this? Best Inga
We recently built a service request for overtime reporting. The SR has two multi-row variable sets and a number of other variables.I need to create a report that uses both sets of variables. This post was very helpful. I've built the database view to...
Hi, Which is the best practice to find old or inactive Reports and Dashboards to delete. Kindly help us with your valuable input. Thanks, Nagaraja
Hi Everyone, I have been reading and trying to accomplish this so any help would be great.What I want to accomplish is having a report of all tickets that are active within a certain period. By active I don't mean SN terms - I mean that were opened/c...
Hi, The facts table is custom table in the Indicator source and the table has a field called Breakdown which is of choice type. It has same values as syslog_transaction table 'Type ' feilds and it was added manually to the Breakdown field in the cust...
Hi everyone, i would like to do a report who give me the results of the tickets resolved in the last 3 weeks each week separately and who have resolved this tikcet here an exemple of how the result should look like.
I'm curious if it should be possible to grant Report access to a table (my use case involved a custom table) with just a Report View ACL and NOT a traditional Read ACL. This was a traditional List type report, not an aggregate- but for user interfac...
Is it possible to have Date filter on top of the dashboard in breakdown source area which acts as an interactive filter on dashboard. i have PA widgets which dont work on interactive filters available on dashboard, therefore its needed to have breakd...
Hello,Can someone tell me which table hosts the priority field? I have an interactive filter for Assignment group and when I create a reference filter, I use the table - > Group (sys_user_group) and this returns all the groups in our system.I'm looki...
I'm a bit of a Performance Analytics newbie so not sure how to do this. Does not seem to be a way to do this in the standard reporting. We've been asked to provide a metric that shows the number of days since the last incident occurred (that meets a ...
Hi friends!So, I need to creat a list type report from the pm_project table. However, in that list I also want to show the columns from the project_status table, to see in the list view if the most recent status is green, yellow or red.For that, I cr...
I have recently added a report on an existing dashboard which I created but that report is showing the error above. How do I lengthen the time allowed for timeouts for this report? I can't seem to find any settings to fix the above issue.
Hello, I have a requirement where I need to create a drop-down interactive filter. The problem is the field type for category is string. Sample values are Desktop PC and Monitor. In drop-down, I need to display these two values only. My display field...
Hi- I have an existing shared dashboard that I have been asked to basically replicate into a new one and tweak all of the underlying reports to show different filtered versions. When I choose to insert and stay on the dashboard I want to copy, I los...
We send assessments out on each completed service request and primarily use the Metric Result [asmt_metric_result] table for reporting. This allows us to dot walk to the task table and extended fields to get information about the requested item and i...
