Hi, I think I may be asking too much, but I ideally need 1 report showing the trend of tickets raised on a weekly basis between 8pm on a friday though to 8am on a monday, by priority. I have figured out trend but you can't chose hour and day togethe...
Hi all, I'm trying to set up a Cascading filter, but can't get it to work. My reports that this filter should run on are on the task_sla and sc_req_item table. We have two choice type fields on the sc_req_item table (inherited from task table) call...
Hi All,We are looking for a solution in Reports. Can we create a Dynamic title for the report in Dashboard? Like we want the title as the dynamic format - "some name, +month/date".Any leads would be appreciated.Thank you!
Hi All, I would like some help on interactive filters. Specifically, I'm trying to get a true/ false filter relating to a referenced field: I have a report showing Vulnerable Items, I want to be able to filter these Items based on whether the CI is '...
Hi I want to create a report that groups and counts projects with same business applications. This field is a List Collector so it can have multiple entries. What can I do to split this field for reporting purposes? I tried database views to join p...
I have built a Performance Intelligence clustering model -> Solution definition on the Incident table. And it also has built an ML solution. Now if a new incident record is inserted in the table and a train is updated and added to the cluster. How wo...
Adding the tags under the change request table and expecting the same tag to the displayed under cab agenda items table. Change manager will audit the change and provide the tags (audit complete/pending/impact etc.) it's depend on change audit in (ch...
I am trying to scheduled a report in Servicenow using Run functionality : "Business calendar: entry start". But while saving it gives the error "Calendar field can not be empty". But I don't see the Calendar field. How do I achieve it?
I have built a reference interactive filter, but want to specify which field values should show up in the dropdown. It is showing the display value field by default, which for this table is an abbreviated code. I would like to specify a different fie...
I am new to reporting and doing some training. In the meantime I thought I would post this and see if any quick responses. How can I join 2 tables in Create reports? For example if I wanted to join ast_contract to sys_usr to get more information ab...
Hi All, I want to share a dasboard with some people who does not have a license in Servicenow. Can I use pa_viewer role for this? Thanks
Hi all I need to know if it's possibile to change reports title for reports in a dashboard depending on Interactive filter value. Suppose we have a interactive filter on Status field and a report wich show Incident by status. My requirement is to sho...
I am trying to create a similar report in PA that compares Current Month to Previous Months and provides a % difference. Similar to this.
Hi All - How can I view Dashboard Name, Run Date, Who Opened the dashboard are the main columns I'd be interested in reporting on. Thanks! Mark
I have other reports built using the change_request_metric table, but I cannot figure this out. I need to report on all Changes that have the "Definition=Change Approval" and "Value=Authorize" but I need to get the actual TIME STAMP on when the chan...