• 0
Archana

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

Question

Hi,

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.

Avg_metric_CPU.png

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 2

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.

 

 5bcf608b9b9f8_ScreenShot2018-10-23at10_55_12AM.thumb.png.9cb9ba2e7184d7ce9901cfb3e6bc13d0.png

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

Edited by Michael Rodrigues

Share this post


Link to post
Share on other sites
  • 0

Hi. This works for me to look at the Average CPU and Mem usage across all out Citrix application servers on a graph

Hope that helps!

Av.PNG

Av2.PNG

Av3.PNG

Edited by neil.white@radian.co.uk
Added Screenshot

Share this post


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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now