LogViewPlus Support » LogViewPlus Support » Help & Support » Reports - Minute granularity

RE: Reports - Minute granularity

LogViewPlus Support — Thu, 08 Jun 2023 19:12:56 GMT

Correct - the graphs will auto-scale the X / Y axis based on the data range to display. The graph is then drawn to a pre-allocated size and sometimes this can result in a graph that is difficult to read. Unfortunately, this is not something that we can easily resolve. It would be better to address this by changing the granularity or graph type.

I also noticed that you are using a line graph which draws a line between two points. If data is missing for a time range, this can result in 'false' data being shown in the grid as the line does not drop to zero unless an explicit 'zero' value is found. In this situation, a bar graph may be more appropriate.

Also, you may want to check out the Navigation Reports. These reports use the same graphing controls and they might help with giving you a better understanding how the underlying controls behave.

Automatically adding a scroll bar to the charts is not going to be possible. It is very difficult to predict in advance if they are actually needed.

Hope that helps,

Toby

Reports - Minute granularity

IvanW — Thu, 08 Jun 2023 19:11:40 GMT

In the reports section, the time scale seems to be restricted to minutes with the following settings:
[code language="sql"]SELECT Timestamp AS Time, tractionSwitch AS Traction, speedcap as Cap
FROM CurrentView
ORDER BY Time[/code]
Sample rows from execution results:
[code]8 Jun 2023 2:13:16 PM.619 3861 7500
8 Jun 2023 2:13:16 PM.623 3862 7500[/code]
Is there any way to increase the granularity of the graphs by selecting units? The Log entries per minute has a dropdown which is nice, although it doesn't display units smaller than minutes when hovering.

RE: Reports - Minute granularity

IvanW — Thu, 08 Jun 2023 19:00:56 GMT

TO be clear - I'd rather see all values and have a scroll bar, rather than it always fitting to my window.:)

RE: Reports - Minute granularity

IvanW — Thu, 08 Jun 2023 18:56:09 GMT

Ah thank you! I was able to use this and drill down and see that in fact, all values are being plotted correctly, but the graph is small enough that I couldn't see the unit resolution in the hovering. If I restrict the time period, I can see seconds or even ms if it's small enough. The X axis is autoscaling the resolution it seems. If I could force it to a certain scale that would be ideal so I could visualize all the values, even labeling was more course.
Ie with a small time period with same data:

vs larger time period with no other changes:

RE: Reports - Minute granularity

LogViewPlus Support — Thu, 08 Jun 2023 18:37:05 GMT

Hi Ivan,

I am not 100% clear what you are trying to do, but if we look at the problem of "log entries per second" this can be achieved with:
[code language="sql"]select
min(Timestamp) as Time,
count(*)
from CV
group by
datepart(year, Timestamp),
datepart(month, Timestamp),
datepart(week, Timestamp),
datepart(day, Timestamp),
datepart(hour, Timestamp),
datepart(minute, Timestamp),
datepart(second, Timestamp)
order by Time[/code]
This SQL statement will group all log entries by time down to the nearest second of granularity, count the number of entries during the interval, and find the minimum timestamp.

The built in 'Log Entries Per Minute' query does something similar by focusing on the minute interval. It does this very differently (and somewhat hacky) by casting the Timestamp to a small date time:
[code language="sql"]CAST(Timestamp AS smalldatetime)[/code]
The SmallDateTime data type does not support granularity less than a minute.

Does that help the SQL you were trying to write? If not, can you give me more detail on what you are trying to do?

Hope that helps,

Toby