Hi @Leonel Sandroni ,
I trust you are doing great.
Follow the below steps for the answer :
Create a Performance Analytics widget To get started, we'll need to create a new Performance Analytics widget. In the Performance Analytics Workspace, navigate to the Widgets tab and click the "New" button. From there, select the "Indicator" widget type.
Add a data source that retrieves the duration of time that demands are in each state Next, we'll need to add a data source that retrieves the duration of time that demands are in each state. We can do this using a scripted data source. Here's an example script that you can use as a starting point:
var gr = new GlideRecord('demand');
gr.addQuery('active', true);
gr.query();
var results = {};
while (gr.next()) {
var state = gr.getValue('state');
var duration = gs.dateDiff(gr.getValue('sys_created_on'), gr.getValue('sys_updated_on'), true);
if (!results[state]) {
results[state] = {
total_duration: duration,
count: 1
};
} else {
results[state].total_duration += duration;
results[state].count++;
}
}
return results;
This script retrieves all active demands and calculates the duration of time that each demand is in each state. It then aggregates the results by state and returns an object that looks like this:
{
'State 1': {
total_duration: 1234,
count: 10
},
'State 2': {
total_duration: 5678,
count: 20
}
}
- Use scripting to calculate the average time for each state Now that we have our data source, we can use scripting to calculate the average time for each state. Here's an example script that you can use:
var results = data.result;
var averages = {};
for (var state in results) {
var total_duration = results[state].total_duration;
var count = results[state].count;
var average_duration = total_duration / count;
averages[state] = average_duration;
}
return averages;
- Display the results in the widget Finally, we can display the results in our Performance Analytics widget. To do this, we'll need to add a "Data" source to the widget and select our scripted data source. We can then add a new "Formula" metric and use our second script to calculate the average time for each state.
Was this answer helpful?
Please consider marking it correct or helpful.
Your feedback helps us improve!
Thank you!
Regards,
Amit Gujrathi
