search cancel

UIM CABI group trend reports calculates graphs versus tables.

book

Article ID: 244136

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Why does the Group Trend Report graph at the top show a high of 36% but max in the table below  shows 100%?

 

Environment

Release : 20.3

Component : UIM - CABI

Cause

The Graph and Tables use different sql queries.

The Graph is showing an average for the day based on this:

Time Range  Deviation Range in Graph
3 Month       - 24 hour  average value of 24 hours (sample value)
1 month       - 12 hour  average value of 12 hours (sample value)
2 Week        - 6 hour average value of 12 hours (sample value)
1 week        - 4 hour average value of 12 hours (sample value)
3 days        - 1 hour average value of 12 hours (sample value)

 

The table is just showing the Max value for the selected time range.

example (average value that would show in graph) 5, 6, 5, 3, 100, 6, 4 would show on the graph as 21%, but the table would show  max =100.

Resolution

working as designed, graph shows average value based on the above table, while table is the max value of the time range selected.

Additional Information

This has been reviewed by development at the sql query and the code level and is working as designed on DE537999.

Attached file contains the 2 sql queries that are run. This may not work in your environment as the table id could be different. This is attached just for reference and not meant to be run in your environment.

Attachments

1655478641880__Group_trend_report(sql queries).txt get_app