Skip to main content
W
wire1-Visitor
1-Visitor
May 23, 2019
Question

Displaying lots of data points in Time Series Chart

  • May 23, 2019
  • 1 reply
  • 2337 views

Hello,

 

Is there a way to get the time series chart or the value stream feeding into it to auto adjust the number of data points to be shown? When I used the data querry in the composer, I have the option of setting max number of data points. I set it too high, mashup takes forever to load. Set it too low, the chart only draws a small portion of the line and then gives up.

 

I also noticed that the graphs in manufacturing apps work perfectly in that they auto adjust the amount of data points based on the date range. How can I do that in thingwrox composer?

 

Thanks

1 reply

P
PaiChung22-Sapphire I
22-Sapphire I
May 23, 2019

You can always take a date time filter. Do a count first and then decide on how many records to return and which ones.

it's a bit expensive up front though.

    W
    wire1-VisitorAuthor
    1-Visitor
    May 23, 2019

    Thank you for your response. I should have said that I am using a date time filter. I have date time pickers in the mashup that feed into the date time filter of the query. My goal is for the user to be able to pick a date range and then see a trend. Right now, if the date range is small, it works great, but as you add more time to that range, that is where the issues arise. The machine I'm monitoring is supply a new data point about every second.

     

    Is there a way to implement some kind of "significant changes" filter to the query? I don't need to much detail when looking at a month of data, but would like the detail to be there if looking at an hour of data. Or some way to spread the max data points setting across the date range? For example, if max data points is 1,000, it shows up to 1,000 points for one day or one week. Right now, if I set the query to a max of 1,000 data points, it just plots the first 1,000 seconds of data points it sees and gives up on the rest, regardless of what the date range is set to.

    P
    PaiChung22-Sapphire I
    22-Sapphire I
    May 29, 2019

    There are probably a few ways you can approach this, I think the simplest way to do it would be something like.

    first series is your 1000 across your time range, however you use state based formatting to highlight the points that are in an area that you would consider significant - or you publish a table / timelines with significant events

    then drilling into those points or events would give you a zoomed view with more points (either a redraw or pop up)

    Terms & ConditionsAccessibility statement