Lets say I took the OOB "Incident Backlog Growth" indicator and added the OOB "Assignment Group" Breakdown.I would suspect that I could now see the backlog growth broken down by each assignment group in the system. However, what I end up seeing is ...
Hi - I have a simple list report on a dashboard and i would like to allow the users to apply additional filters as needed; however, when i check 'follow interactive filter' on the widget settings it does not show the filter icon and allow to modify...
Fields of type List cannot be selected as the "Group By" on a bar report and I understand why. However, if you click the "Additional group by" button, fields of type List can be selected. Does anyone else see this same behavior or happen to know why?...
I'm trying to run a report on the Schedule Entry table (cmn_schedule_span), but when I try to filter it by the date, the options for the Start Date Time and End Date Time are only "is", "is not", and "is anything." How am I able to filter on normal t...
Hi all, May i ask how can i hide this dashboard tab? It should be seen by manager only. Thank you so much.
Is it possible to duplicate a tab within a dashboard? If so, how? (To be clear, I don't need to duplicate an entire dashboard, which I know is possible. I need to duplicate a tab in a dashboard.)
Hi everyone, I'm using Scheduled Email of Report, but How can change date format of data fields from yyyy-MM-dd to dd/MM/yyyy? Thanks, Gaetano
Script I have:var diff=function(x,y){return y.dateNumericValue() - x.dateNumericValue();};var mins=function(x,y){return diff(x,y)/(24*60*1000);};mins(current.opened_at, current.now);I need something to replace the now that will give me the time diffe...
How to create a record count in database view? I can't do this with core reports. The record should include these fieldsHeader 1Header 2Header 3Header 4Header 5QuestionDatePersonResult= yesResult= No
Hello Everyone, Is it possible to create a report which shows all ticket types? When I try to create a report, I can only select one table for each report. I would like to create a report which will show all the tickets (incidents, requests, etc) our...
Hi,I'm trying to train machine with pre-defined solution definition in my PDI.all solution are going to Unauthorized state.I have admin role, checked credentials and service worker user is active too.Kindly help me with the issue, I'm getting same is...
Seems like a simple request but I'm having trouble getting the previous full 3 months. Using these conditions: Created <relative> at or after 3 months ago AND Created <before> this month I am getting November (partial), all of Dec and all of Jan. Mis...
We have a filed on our incident form called affected location. It is of type list and references the cmn_location table. I have the latitude and longitude set on the location and created a map source but I get the "ERROR: Cannot generate the report...
Hi all, I am trying to create an interactive filter on Incident table with multiple column. Basically I am trying to create an interactive filter for daily, weekly, monthly resolved and closed incidents. for eg, I am trying to replicate this conditi...
Hello,I'm looking for the syntax for how to filter a database view for a field is not null. Example&& inc_major_incident_state="rejected"-If a database view using the incident table had the above filter condition added to the where clause it would re...
