Forum Discussion

Archana's avatar
Archana
6 years ago
Solved

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

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.

average
time range
  • Mike_Rodrigues's avatar
    Mike_Rodrigues
    6 years ago

    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.

5 Replies

Sort By
Replies have been turned off for this discussion
  • Archana's avatar
    Archana
    6 years ago
    11 hours ago, Michael Rodrigues said:

     

    Hi @Michael Rodrigues,

    Thank you so much for your response. Yeah now I can see the values which I really need.

    The answer is really helpful.

  • Neil_White's avatar
    Neil_White
    6 years ago

    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!

  • Archana's avatar
    Archana
    6 years ago

    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?

  • Archana's avatar
    Archana
    6 years ago

    Can anyone please provide your suggestions on this? I am unable to proceed further on this. Please help

  • Mike_Rodrigues's avatar
    Mike_Rodrigues
    Icon for Product Manager rankProduct Manager
    6 years ago

    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.