Platform Analytics forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Multi-level Pivot Table with Multiple Columns

I'm trying to create multi-level pivot table on benefit_plan table to the format as below* Tried inserting the required fields in column but it doesn't show as the table above.  Wanted to explore multiple data sets to construct this table, but don't...

find_real_file.png
SK51 by • Tera Contributor
  • 2845 Views
  • 2 replies
  • 0 helpfuls

CMDB Health Calculation

Hey guys, We need the ability to trend the CMDB Health scores.  I'm having a hard time reconciling the denominator in the health calculations.  The only one I was able to line up was the denominator in the duplicate calculation.  Where are these numb...

find_real_file.png
Tim McCarthy by • Tera Contributor
  • 5331 Views
  • 5 replies
  • 0 helpfuls

How do I add a trendline to a line graph report?

Hi all I created a line graph report for the number of incidents received by the Service Desk over a 5 month period (see below).   I would like to add a trend line (a line that shows the mean number of incidents over that 5 month period). I would be...

find_real_file.png
Mike128 by • Kilo Contributor
  • 10143 Views
  • 12 replies
  • 4 helpfuls

Resolved! Creating a formula for a Report

Hello all, Background: I have formula indicators set up that show the following: (([[SOM - Number of new incidents > Priority = 1 - Critical]]) * 125) + (([[SOM - Number of new incidents > Priority = 2 - High]]) * 25) + (([[SOM - Number of new incide...

find_real_file.png
jendugan by • Mega Contributor
  • 9783 Views
  • 9 replies
  • 3 helpfuls

Resolved! Create report based on sys_report_users_groups table

We are trying to do an audit on report access and I've found that the best table to use is sys_report_users_groups . The only issue with this is that the table visibility is only available for admins. We were able to create a database view joining sy...

Danielle25 by • Kilo Expert
  • 4838 Views
  • 6 replies
  • 1 helpfuls

Cannot add Widget to Dashboard

I have been working with dashboards and widgets for a while now, in different versions. Currently I am running instances of London and Orlando. Lately, the filtering when trying to add widgets to a dashboard, does not seem to behave the same anymore....

find_real_file.png find_real_file.png find_real_file.png find_real_file.png

Resolved! PA Indicator breakdown on database view not working

Background (the ask): Using the SAFe module, I need to provide trending data on the average amount of time tasks (User Stories, Features, Epics) spend in each State, broken down by State and Team.  To accomplish this, I have set up 2 Metrics Definiti...

Jason184 by • Kilo Contributor
  • 3923 Views
  • 6 replies
  • 1 helpfuls
Labels