Resolved! How to change the duration of calendar view in a report
How to change the duration of calendar view in a report? I want to make the duration longer, not an hour, the duration of the field I defined
Forum Posts
Resolved! JavaScript evaluation returned: NaN in script error in Data collection Job
I was trying to calculate the business duration in days using a script which used for breakdown mapping of 'business duration age' breakdown with 'business duration' field in Incident table.My daily collection job ran without any error but when I ran...
Business time left in export to excel
Date, Date-Time, and Time fields are all exported as their display values, displayed using a custom format instead of the system date format. Duration fields, however, export as the value stored in the database, which is an integer value of seconds.T...
Report showing incidents between 8pm fri and 8am mon - how???
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...
Resolved! Cascading filter problem
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...
How To Create Dynamic Report Title In Dashboard?
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!
Resolved! Boolean inteactive filter on a referenced field
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 '...
Resolved! Create Report based on list collector field
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...
Predictive Intelligence - Clustering -> How to show on a record level?
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...
We are able to add the 'Tags' fields to our columns list in the settings under our CAB meeting definition entry. However, when we run/export the report, Tags columns shows empty for all the changes that come up in the list. We could see the tags deta
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...
Business calendar: entry start option in scheduled email of reports
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?
Resolved! How to specify display view of dropdown options for reference type interactive filter
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...
How can I join tables in Create Reports?
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...
Does pa_viewer role consume license?
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
Report Title in dashboard
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...
