The bars in bar charts are not placed correctly on the x-axis.
The lowest value has been measured between 11:25-11:30 but it is displayed on the bar chart between 11:30-11:35.
The line chart is displaying the data correctly.
Foglight is working as designed.
Below further explanation:
Export the data as xml by using the export feature of the charts. In the export you will see that the base data of all charts are the same.
Snippet from the XML exports:
2011-02-07T11:25:15.241Z
2011-02-07T11:30:15.241Z
281.0
281.0
281.0
281.0
The bar chart is a discrete and discontinuous chart. It buckets the data. It will request data aligned to 5 minute boundaries with 0 seconds. Hence the above sample with endpoint 11:30:15 will get placed in the 11:30:00 -> 11:35:00 bucket. The bar chart will draw this sample in a cluster centered at 11:35:00, which is the endpoint of the bucket.
The bar chart is treated differently from a line chart because a line chart is continuous and a bar chart is discontinuous. A line chart does not require data to be divided into buckets. A bar chart requires data to be divided into buckets.
The metric table does not bucket data. It simply displays the data it is given but does not display the seconds. So it displays the sample with 'Success = 281' in the 11:25(:15) to 11:30(:15) row.
The decision to align the data to boundaries with 0 seconds was a deliberate design decision. The cutoff has to be made somewhere within bar charts.
It is related to when the agent starts to collect data. If it starts data collection at hh:mm:00, the bar chart will line up with the metric table and line chart because all use time slices of hh:mm:00. But that is highly unlikely, which is why we recommended the use of a line chart instead of bar charts.
If the Drag&Drop charts do not fit the requirements, define your own queries and create charts based on that queries.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center