I am trying to create a report on incident table based on SLAs. I need to apply SLA business elapsed time explicitly for each priority in conditions. So in related list conditions i am trying to add multiple new criteria on task SLA table to fetch th...
I have a simple requirement to calculate First Call Resolution. I would like to use a single value report or even a means on this report to calculate ((FCR eligible/Total Calls) *100). How do I calculate totals off a report? Also, I realize there ...
Hi everyone, I am new to Platform Analytics but have experience using Dashboards and Reports. I am trying to add a filter to my PA Dashboard to select from Vendors used on my Contract table. Whenever I select the dot-walked field Contract.Vendor, it ...
Hello, I want to create a report with multiple rows (two variables) and Count as the single column, like this: I have already implemented the workaround described in the discussion below (create a multi-level pivot table and add the active field as t...
If there is at least one closed change task, it will be included in the results, regardless of any remaining open change tasks for the same change request. However, I need to retrieve all change request tickets only when all change tasks are closed.
It is with regards to the out of the box dashboard "IT Manager". Recently our instance upgraded from Vancouver to Washington with that Platform analytics also migrated to new Platform Analytics Experience. Post migration the out of the box dashboard ...
Hi all,I have modified this script I found to try delete multiple records but so far it fails.I am going to be using the scripts background function as it is just a 1 time event. The records are before the 1st of April so I added an encoded query. Ca...
Hi All,I've read several similar questions and been through the answers. Needless to say I'm left needing to ask my own question.I want to use the OOTB Reporting module (version=helsinki) to report on all tickets assigned to a group (I'll actually us...
I am looking to create a report that will bring in all of the Change Requests approved underneath of a manager? He runs 11 mnemonics and wants a report of all of the changes approved inside of his "tree."I was adding in all of the mnemonics separatel...
There is a requirement from one of the operations team to filter on the worknotes field in a Change ticket. Now since, the worknotes is a journal field, we wont be able to filter on the same. However, i came up with another filter condition to Filter...
Building apps using AES with custom (fulfiller) roles created in AES for the applications. The stakeholders want the custom app fulfillment team to be able to create and share dashboards. The following docs page states that "Any role" can create, edi...
I have set up a spreadsheet which we currently use to display our Service Desk stats on: Incidents Resolved, Incidents Updated, etc.I have daily scheduled reports which run from SNOW, but currently, I have to receive the report, then update excel man...
Hello, I need to create a report, that will require data from at least 4 different tables. It was mentioned that I need to use/create a database view. I've never done this. Is this what I need to do? Or is there another way to display data from multi...