• 0

How to find Average value of a metric/field for a particular time range

Go to solution Solved by Michael Rodrigues,



I am trying to collect the average/max value of a field or metric only for a particular time range which we choose. I am unaware through which kind of Widget I can show the average/max value of a particular time period as a single value.

I tried using Gauge & Big Number Widget to show my single average value for a specific time period. But the problems are as follows:

1. Big Number Widget - will show only the single value but it does not have any type of aggregation function (Min, max, avg)

2. Gauge widget - Contains Aggregation function to select. But not sure whether it is aggregating the field values according to the time range we select. Because everytime when the Dashboard/Widget is refreshed according to the Refresh Frequency, it is showing different values. For example, if I select the time range from March 1st to March 31st, then aggregate values should be same as it is not the real-time occurence.

I tried with Graph Widget (refer the attached screenshot Avg_metric_CPU), it is providing me the proper values of that time. But I need the data to be shown as single average value, monthly-wise.

Could anyone please help me on this.


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 2
  • LogicMonitor Staff
  • Solution

Hi @Archana, I think we do what you're looking for, but the feature is sort of hidden.

Open the expanded graph, then expand the instances pane at the bottom.

On the right side of the instance pane, there's another downward pointing arrow. If you click on that arrow and select "Show Boundaries' you'll see min/max/avg for each instance for the selected time range.



You may have to aggregate instances into one to get the average across multiple instances.

Edited by Michael Rodrigues
Link to post
Share on other sites
  • 0

Hi @neil.white@radian.co.uk,

You have tried with Graph representation. That is even working for me without any issues. I can get the average value of my CPU in a graph format for every 'x' span of time.

But my requirement is I need the cumulative average value of my CPU for a whole month (something like average of all the CPU values for the whole month in one single value).

I am aware that, to display one single value, we have the widget called 'Big Number'. But the problem is when I select the time period as per my requirement, there is no impact in the data values displayed over the Widget.

Not sure how to achieve this and not aware which period of data the Big Number Widget consider and present us.

Any idea on this please?

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.