Solved

How to graph seconds minutes hours, together?

Posted on 2014-09-23
11
493 Views
Last Modified: 2014-09-24
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
Comment
Question by:projects
  • 7
  • 2
11 Comments
 
LVL 27

Accepted Solution

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

Author Comment

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

Author Comment

by:projects
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 100

Expert Comment

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

mlmcc
0
 

Author Comment

by:projects
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:projects
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

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

Expert Comment

by:mlmcc
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

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

Author Closing Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The task A number given should be formatted for easy reading by separating digits into triads. Format must be made inline via JavaScript, i.e., frameworks / functions are not welcome. So let’s take a number like this “12345678.91¿ and format i…
This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This video teaches viewers about errors in exception handling.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now