Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
XY Line Chart With Irregular Datetime Data?
Migrateduser
Hello,<br />
I really hope that I don't duplicate a topic. I was searching and didn't find an appropriate solution.<br />
<br />
So I want to draw a line chart, with datetime on one axis and number of events on the other axis. The data is more complicated but can be simplified to express what I mean (originally it comes from a log database via scripted datasource)<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
DATETIME (Date) EVENT (String)
2012-12-04 11:25:13 event1
2012-12-05 08:56:10 event2
2012-12-05 09:32:54 event1
2012-12-05 10:20:01 event1
... ...
</pre>
<br />
What I would like to have is a line chart with n series, for event<sub class='bbc'>1</sub> up to event<sub class='bbc'>n</sub>. On the x axis there should be a nicely looking date/time listing with regular intervals (ideally the axis would scale based on the data provided, i.e. if the datetime range is 1-2 days, it should build aggregates for an hour or so, if the datetime range is 2 years, it should build aggregates for months). On the y-axis then there would be the count of events for each time-aggregation-period, i.e. <br />
2012-12-04 -> 1, 2012-12-05 -> 2 (for event<sub class='bbc'>1</sub>) and 1 (for event<sub class='bbc'>2</sub>) and so on.<br />
<br />
You don't have to provide a fully working example (although I wouldn't mind) but any help would be appreciated (in particular, if I have to write scripts, where do I enter them etc)<br />
<br />
Thanks alot in advance!
Find more posts tagged with
Comments
There are no comments yet