Color based label for average response time and baseline time

Index Fields : TimeElapsed , URI, Operation and API Name.

Based on above I need to create a data table with API Name, URI , Operation , Time Elapsed , BaselineTime and Color Label.

where : Baseline time is static value that needs to be pushed in seperately maybe as sctipted fields . But since the list is long the script is also getting long.

Color Label = Average (TimeElapased) < Baseline Time = Green
Average (TimeElapased) > Baseline Time = Red

How should i proceed with this 3 scripted fields for baseline Time, Average Time and Color Label or any other way.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.