Solved

How to graph seconds minutes hours, together?

Posted on 2014-09-23
11
459 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
Comment Utility
You could use a logarithmic scale.
http://en.wikipedia.org/wiki/Logarithmic_scale
0
 

Author Comment

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

Author Comment

by:projects
Comment Utility
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
Comment Utility
So you aren't using Crystal Reports?

mlmcc
0
 

Author Comment

by:projects
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:projects
Comment Utility
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
Comment Utility
@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
Comment Utility
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
Comment Utility
Looks commercial however, so if that's the case, I cannot use it at this time.
0
 

Author Closing Comment

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

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The viewer will learn how to implement Singleton Design Pattern in Java.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

762 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

9 Experts available now in Live!

Get 1:1 Help Now