Solved

How to graph seconds minutes hours, together?

Posted on 2014-09-23
11
536 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
[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
  • Learn & ask questions
  • 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
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
 

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
The viewer will learn how to implement Singleton Design Pattern in Java.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Suggested Courses

752 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