Time Series Chart - Visualizing Hrs/Min/Sec

Comments

15 comments

  • Avatar
    Jay Dastur

    Hi Jim 

    #1

    The tool-tips should now respect the format set on the measures. Please check.

    #2

    I have uploaded the plugin under a new name. TimeSeriesChart. So as not to override the original zoomable line chart plugin. 

    #3

    Rendering as a step line seems to be the culprit when it comes to poor performance. I set the default to render as a regular line chart.

     

    0
    Comment actions Permalink
  • Avatar
    Jim Thomas

    Jay,

    One more comment.  I was incorrect on Zoom not working in Safari.  Does work, but just so slow I didn't realize it.

    Jim

    0
    Comment actions Permalink
  • Avatar
    Jay Dastur

    Hi Jim

    What do you mean by lines ? The horizontal grid lines of the plot area ?

    I have tested this on a mac book air 4GB RAM  on chrome and safari 6.2.8 and they both render fine.

    Remember this is an enhancement of the highcharts zoomable line chart. I have not implemented the complete rendering !!

    N/W speed could make a big difference when potting a large number of points.

     

     

    0
    Comment actions Permalink
  • Avatar
    Jim Thomas

    Jay,

     

    By lines, I mean the plot lines.  On Chrome on the Mac (OSX Sierra, latest version of Chrome), they only render in the widget design screen.  Once I hit Apply to return to the dashboard, they no longer render.  They render fine on Safari, but very slow as previously described.

    I'd be surprised if network speed was the issue on the Mac.  Typically have 18 mb/sec download speeds.  I'm available for a web conference to demonstrate on Thursday if you want tot take a look.

    Regards, Jim

    0
    Comment actions Permalink
  • Avatar
    Larry Craig

    I'm attempting some mild modifications to the widget, with the goal of enabling a few specific Highcharts features, but am experiencing mixed success.

    I'd like to enable the following:

    • Crosshairs (Not working/visible)
    • Navigator (Works, but doesn't display selection handles or allow restyling)
    • Range Selector (Not working/visible)

    Widget Image, showing the navigator pane

    I've added the following code to the Widget.js within the 'var options={}' section of code:

    //Navigator Stuff
    navigator: {
    enabled: true, outlineColor: '#999999', outlineWidth: 2,
    handles: {
    backgroundColor: '#f2f2f2', borderColor: '#999999'
    }
    },
    //Range Selector
    rangeSelector: {
    selected: 4, inputEnabled: false,
    buttons: [{
    type: 'millisecond',
    count: 15000,
    text: '15s'
    }, {
    type: 'millisecond',
    count: 60000,
    text: '1min'
    }, {
    type: 'millisecond',
    count: 300000,
    text: '5min'
    }, {
    type: 'millisecond',
    text: 'All'
    }]
    },
    //End Navigator Stuff

    Any ideas on what I might be missing?

    Thanks,

    Larry

    0
    Comment actions Permalink
  • Avatar
    Thirumala Raju M

    Hi Jay,

    I am trying to use this plug-in for my time series data.

    Created a custom field with following column column expression.

    (DayDiff([END_TIMESTAMP], CreateDate(1970,1,1)) * 86400000) + (GetHour([END_TIMESTAMP]) * 3600000) +
    (GetMinute([END_TIMESTAMP]) * 60000) + (GetSecond([END_TIMESTAMP]) * 1000)

    In this case, [END_TIMESTAMP] is the field with Date-Time data type.

    Column Expression is showing no errors (Parsed successfully) . But preview result is showing the following error message.

    Value was either too large or too small for an Int32. Couldn't store <1496276100000> in UNIX_TIMESTAMP column. Expected type is Int32

    Can you please help me in this.

     

     

     

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    @Admin Greenko - try changing the custom field type to bigint, that should help. 

    0
    Comment actions Permalink
  • Avatar
    Thirumala Raju M

    Custom field data type is bigint only.

    0
    Comment actions Permalink
  • Avatar
    Jay Dastur (Edited )

    Note:

    There is an issue with previewing a big int field in the Elasticube Manger. So when you try to preview the table with the big-int expression for the Unix Timestamp. You will get an error message. Ignore it.

    It should render fine on the dashboard.

    0
    Comment actions Permalink
  • Avatar
    Thirumala Raju M (Edited )

    Hello Jay,

    I am able to trend the time series data using he unix timestamp field. But the label format is showing incorrect month name.

    Can you please check the below screen captures which show Aug, 14, 2017 for Mon, dd, yyyy format and 07/14/2017 for MM/dd/yyyy format.

    The actual data is for 14th July.





    Regards,

    Guru

     

    0
    Comment actions Permalink
  • Avatar
    Mike Scally

    I was getting this error eventhough i set the field up as a bigint 

    Value was either too large or too small for an Int32. Couldn't store <1496276100000> in UNIX_TIMESTAMP column. Expected type is Int32

    The fix was to Convert the result of the formula to a bigint using the ToBigInt function like so 

    ToBigInt((DayDiff([DateField], CreateDate(1970,1,1)) * 86400000) +

    (GetHour([DateField]) * 3600000) + (GetMinute([DateField]) * 60000) + (GetSecond([DateField]) * 1000))

    0
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Thanks Mike!

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Jay,

     

    I've a very strange issue. I've few different series I want to plot on the chart, and I select what to plot by a filter on dashboard level. When I select some of those series, the chart does not display full time range. I have data from 24-11-2017 until today and chart cuts it at around 9th of January. When I display it in different visuals it shows properly full time range. Any hints what could be wrong with such behavior? Thanks in advance!

    Regards,

    Micahł

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi,

    just bumping this to get some attention :) The issue mentioned above is becoming quite problematic.Thanks in advance!

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi,

    when using values more than one advanced formula (not a simple SUM or AVG), the chart won't plot the second or later value. It will plot the first one and that's it. Any potential fixes for that? 

    Regards,

    Michał

    0
    Comment actions Permalink

Please sign in to leave a comment.