Cognite Charts: A way to explicitly set the TS granularity

Related products: Charts

I think the automatic granularity used in Charts works very well, and 90% of the time it selects a granularity that is appropriate. However, in some situations I would like to actually use a finer granularity than the automatic one.

How exactly the UX should be for setting this, I am not sure. One option is to place a granularity selection button next to the TS color button in the table. A more fancy solution could be to bind a keyboard key to the mouse wheel, so that when ALT is held while scrolling the granularity is automatically updated and displayed in the table.

 

Regards,

Anders Brakestad

@Anders Brakestad are you referring to having control over the granularity for time series, calculations, or both?

For time series, this would obviously be only for visualization purposes whereas calculations could be for both visualization purposes and/or for specifying the granularity of the calculation workflow, itself (something we are aware of as a high-value request to make calculation aggregation more predictable and trustworthy).

And what sorts of granularity parameters (seconds, minutes, hours, days, etc.) are you most interested in or expect to use most frequently?


Hi @Anders Brakestad, do you have any follow up input to this? :) 


Hi @Anders Brakestad,

For the moment, we will put this idea to parked status because we haven't heard back from you for a while. We would be happy to reopen it if you get back.

Best regards,
Dilini


@Anders Brakestad are you referring to having control over the granularity for time series, calculations, or both?

For time series, this would obviously be only for visualization purposes whereas calculations could be for both visualization purposes and/or for specifying the granularity of the calculation workflow, itself (something we are aware of as a high-value request to make calculation aggregation more predictable and trustworthy).

And what sorts of granularity parameters (seconds, minutes, hours, days, etc.) are you most interested in or expect to use most frequently?

 

It is difficult to say which granularity will be most used. It depends on the use case. I guess “All of the above” will be relevant in data exploration. My point is that you give the user more control of how the data is visualized. Would it not be possible to allow for arbitrary resamplings of the frequency by letting the user specify “1hour”, “14days”, etc?


Hi, 

I’m still a bit uncertain what granularity you are referring to. Do you mean when viewing a time series and choosing different time windows?

Today, it automatically shows raw data points when it’s less than 1000 datapoints. Above 1000 datapoints we show aggregates (in the same way as in API calls). If not, the UI will quickly become very sluggish and give a bad user experience.

I like your idea of making this a user preference. This will come with the “danger” of creating a very slow experience, if we choose to include it. We’ll keep this thread open for comments from other users as well.

 

Best regards, Knut


NewGathering Interest

I would like to be able to control both the time window and the time series granularity in the specified time window. For example, I would like to specify a time window of “1year” and then specify a time series granularity of “12hours”. Indeed, if you put a granularity of 30 seconds on a time series spanning 10 years with 350 million data points, then

 

But my vote is for flexibility over restriction. The functionality could be hidden in a way to avoid accidental settings, or display an “Are you sure” box if the number of data points returned by the request exceeds a certain threshold.

:) 


Understand,.

Thank you for the clarification!

Knut