search cancel

UIM CABI group trend reports calculates graphs versus tables.


Article ID: 244136


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


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



Release : 20.3

Component : UIM - CABI


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.


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.


1655478641880__Group_trend_report(sql queries).txt get_app