I have a pivot table report on a custom table that is looking at the state and type of request. When I click into a cell to see the list of tickets, for example Type = Contracts and State = Open, I want to add more columns to the list view. I've open...
I am new to performance analytics. I have created the formula indicators, I have run the jobs to gather data successfully, yet, the forumlat indicators return "no data available" when I look at the score card. I am obviouly doing something wrong bu...
To Whom it May Concerned,I created a formula indicator and add it to indicator group. But I could not add such indicator to any job. Therefore, I could not generate any records to my widget.I looked into OOB formula indicator and saw records populate...
Hi everyone. Sorry if this is something simple but I'm struggling to get my head around this in our current Geneva system.I have 2 automated indicators set to pick up data for the current month, running daily. From these 2, a formula indicator calcul...
I am trying to create a Fiscal Year Indicator to be able to collect Fiscal Year to date or Fiscal Year Sum + scores.After I created a Fiscal Yearly indicator source, and try creating an automated indicator, its giving me an error: Frequency should be...
Has anyone ever performed a metric duration calculation via a business rule? I have the below metric business rule that monitors reopened incident records. I'd like to calculated the duration between the mi.start and mi.end and populate the gener...
HI,I have created a database view on a table, I need to create a new column in database view without creating in the main table, So that I can use the newly created column in the report which is on database view table.How this can be achieved?
Is there any way/workaround to arrange for job data collection parameters using a (fixed start date)/(relative end) combination?It does not appear to be possible to configure the collection parameters as with the mock-up above but is there any way to...
Is there any way that anyone knows to produce a breakdown dashboard similar to the below image? I am using Widget Type = Breakdown; Visualization=Scorecard with Follow Element selected to Selected Group. Problem is that when 'Show Indicator' is set t...
Hello,The title says it all. I want to have a breakdown on the 'Article code' field on the 'Product Model' (cmdb_model) table.As we can't create automated breakdown on fields other than references and sys IDs, I want to create a manual breakdown and ...
Hello all,I am working with some Breakdown Scorecard type widgets to display Percent of Changes Closed on Time, as well as a few other similar reports, by various groups within our company. The widget is set up to display regional data by break out g...
Hello Everyone,I'm trying to get a report for Licensed Users. By creating a report on sys_user table with below filter conditionsys id is javascript:gs.getRoledUsers();The result gave me licensed users. But it includes the users who are having only r...
Hi Guys,Have two problems. 1. I can't find nothing about why the heck I cant schedule a Multilevel Pivot Report? 2. Step 1 was my only hope to schedule this report into excel and editing this in excel.I run a report that needs to show me the amount o...
Hi Experts,I am trying to create a simple indicator that shows me the tickets with no updates since 30 days or more. The indicator seems to be returning the right value but the dates are a bit mis-matched. For example, in the below screenshot, you ca...
Hi,I'm trying to create a table style report to show the number of completed tasks per month by each assignee. Something like this:However, I am unable to do this in a table as my options to trend are only available on column charts.Any advice woul...
