Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# How to graph seconds minutes hours, together?

Posted on 2014-09-23
Medium Priority
564 Views
A problem which I am having and cannot seem to find a solution to is that of creating a report for time based events to show a visual over time.

An event being something, anything, which can be from 1 second long to many hours long.
When trying to create a graph to show events over time, the problem is that the Y axis is never possible because the range is too great.

Say there there are 30 events in a graph, some are 2 seconds long and some are one to many hours long. Now let's say that green is seconds, orange is minutes and red is hours.
We are using a bar graph because these are individual events so each bar represents one event.

The graph ends up showing a miniscule green lines which are barely seen while hour long events show up as huge red bars going past the top of the graph. No matter how we adjust the Y axis, this always happens. If we make the Y axis a short period of time, then we can see the short events but long events are just huge bars. If we make the Y axis a long period of time, then we can see the long events nicely but the short events nearly disappear.

Since we need to show ALL events so that we can get a visual over time, it means that we cannot separate s/m/h events, they all need to be together in the graph.

So the question is, how in the world can this be dealt with???
0
Question by:projects
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 7
• 2

LVL 28

Accepted Solution

rrz earned 2000 total points
ID: 40340676
You could use a logarithmic scale.
http://en.wikipedia.org/wiki/Logarithmic_scale
0

Author Comment

ID: 40341780
Can this be done using one of the nvd3 graphs? That's what we are using.
0

Author Comment

ID: 40341783
stackoverflow.com/questions/14648096/how-to-draw-logarithmic-line-charts-with-nvd3

Problem is, I need this for bars since the events are individual items. A line chart doesn't work.
0

LVL 101

Expert Comment

ID: 40341861
So you aren't using Crystal Reports?

mlmcc
0

Author Comment

ID: 40341900
Could the events be converted into numbers instead of time, to represent events. When the user mouses over the event, then we could give them the details of the event.

By numbers, I mean that time would be converted instead to a representation of some kind. Again, this has to be bars so the shorter the bar, the shorter the amount of time of the outage. The longer the bar, the longer the amount of time for that outage, etc.
0

Author Comment

ID: 40341903
It was suggested at one point but no, we ended up going with nvd3 because it allows non and commercial use without any problems. I don't know what Crystal allows.

Once the project is running and has shown possibility, then there will be a budget to use what ever we need. However, it would still have to run for a substantial amount of time using only free tools first.
0

Author Comment

ID: 40341962
@mlmcc; Are you talking about nvd3? Guessing not since nvd3 doesn't seem to have that option in right click.
0

LVL 101

Expert Comment

ID: 40342052
No, I was referring to Crystal Reports since you asked the question in that topic area.

There is a version of Crystal that comes with (or can be downloaded) Visual Studio.

You could convert the times to SECONDS or MINUTES.  Those would preserve the relative sizes and would unless the magnitudes are vastly different  be visible on a chart.

mlmcc
0

Author Comment

ID: 40342061
Looks commercial however, so if that's the case, I cannot use it at this time.
0

Author Closing Comment

ID: 40342093
This reply lead me to searching for related solutions and we have found an answer based on this.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how â€¦
This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define â€¦
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
###### Suggested Courses
Course of the Month7 days, 17 hours left to enroll