• 0

Is there a way to report on the maximum value per day that a metric reaches?


Mason
 Share

Question

Hello everyone, currently trying to create some dashboards for our organisation.

I'd like to be able to see peaks for certain Datasources/Resources in general but I would like to be able to display this on a dashboard or on a widget. I can't find a way to get this to work so far, has anyone got anything setup similar? How did you get this to work.

Thanks in advance.

Mason

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0

Kinda. The Gauge widget has a Peak option. It only applies to one datapoint/device at a time though so if you need a lot of them it's not that great. The graph widget can show min/max/ave in the legend but I'm not aware of a way to force that to always show on page load.

 

Link to comment
Share on other sites

  • 0
  • Administrators

You can create a virtual datapoint on a graph that does domain aggregation (sum/min/max/average): https://www.logicmonitor.com/support/dashboards-and-widgets/managing-widgets/widget-configuration#Adding-Virtual-Datapoints-perform-a-calculation

The summary is over the entire timerange of the graph, so if you want to look at 30 days and see the max for each day, that's not what this does.

Link to comment
Share on other sites

  • 0
  • Administrators

There is consolidation and aggregation, then there is domain aggregation:

Consolidation is where data is combined along the x-axis. For example, if your data is obtained every 1 minute, displaying that graph over 3 months would result in roughly 130,000 points along the time axis (x-axis) per instance. The consolidation function of a graph's datapoint determines how that large number of datapoints is simplified to make the graph display-able and readable. Choosing average as the consolidation means that the graphing engine will combine roughly 5 hours worth of data into a single point and graph that one point, representing the entire 5 hour timeframe.

Aggregation is where multiple instances are combined together vertically according to a function. You would do this if you wanted to know the total bytes of storage free across all instances, for example. You would enable aggregation and choose "sum" as the aggregation method. If you wanted to know the average CPU across all CPUs included in the graph (according to your filters), you would enable aggregation and choose the "average" aggregation method.

Domain aggregation is where you use a statistical formula to describe a single trend line using a single descriptor. You can create a virtual datapoint that uses domain aggregation functions. These functions take into consideration all data currently displayed, so they're calculated at runtime. While the linked page talks about complex datapoints, the percentile functions can only be used in virtual datapoints (not complex datapoints). 

Link to comment
Share on other sites

  • 0

Thanks. I did some testing but the only functions that seem to work as domain aggregation, where you get a straight trend line, is percent and rawpercentile. The other functions seems to use the point-in-time value rather than all the data displayed, unless you do something that always outputs the same value regardless of the datapoint value, like just providing a static number. Cool that you can use something like percent(datapoint,100) and percent(datapoint,0) to get the max and min of the graph shown though!

 

image.png.516b42a51a8d013ae190cc0f0964fe80.png

Thanks!

Link to comment
Share on other sites

  • 0
  • Administrators

Yes, there is some work that needs to be done here. Likely the UIv4 transition will completely change things. "pow" is expected because you're only taking the current value and raising it to a power. Similar to other simpler arithmetic functions like a + b. 

Yes, percent(0) and percent(100) are the easiest, although not most intuitive ways of getting the max and min on the graph as flat lines.

Link to comment
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.

Guest
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.

 Share