Show median in widget on dashboard

[AndersBGS]

Hi all,

I'm trying to figure out how to show the median in a widget on a dashboard. Neither the report designer or performance analytics have any option to do this, so I would think that a scheduled script is needed. I have search the community, google etc. to find a sustainable solution, but haven't seen one yet. What I need specific is, to put the duration field from cmdb_ci_outage table into an array. By doing this, I would think that below script can help with the rest:

function median(values: number[]): number {

  if (values.length === 0) {
    throw new Error('Input array is empty');
  }

  // Sorting values, preventing original array
  // from being mutated.
  values = [...values].sort((a, b) => a - b);

  const half = Math.floor(values.length / 2);

  return (values.length % 2
    ? values[half]
    : (values[half - 1] + values[half]) / 2
  );

}

I would think that the output then can be entered into a scorecard on a manual indicator, but please let me know your thoughts, if any other solution is sustainable - I am open for suggestions.

Best regards

Anders