[ZBX-23597] Zabbix Dashboard topN widget improperly sorts floating point numbers Created: 2023 Oct 24  Updated: 2023 Oct 25

Status: Confirmed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: 6.4.7
Fix Version/s: None

Type: Problem report Priority: Major
Reporter: Dave Johnson Assignee: Zabbix Development Team
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

rhel8


Attachments: PNG File image-2023-10-23-19-08-46-921.png     PNG File image-2023-10-23-19-09-02-838.png    

 Description   

Steps to reproduce:

  1. The topN widget isn't showing the topN or bottomN values properly for me.
  2. I'm trying to sort a floating point field, of ptp ofsets which show time down to mcroseconds.   I'd like to see which hosts have the worst offsets, which is actually really useful in determining network buffering and network application issues...  Not to mention its important if you have a lot of data going between hosts and you need to look at timestamps of data in various places....  
  3. In any event, and it looks like the zabbix widget sorts a 64 bit signed number as scientific notation with the sorting on the mantissa (2.6e-10 vs 3.5e-9 it will home in on 2.6 and 3.5 as an example): 

Result:
See screenshots..  I provided a top screenshot as well as a "bottom 12" screenshot.

Expected:
Properly sorted; which it is not...! 


Generated at Mon Apr 07 02:19:29 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.