Need to co-relate Events with Timeseries

HI Team, 

Any inputs would be appreciated!

Thanks in advance!

Regards,

Arati

Events are associated with Assets. You will have Asset Id field in Events table which you can link with Assets table. The Assets and Timeseries table has one-many relationship already

@Ankit Kumar Thank you Ankit for your inputs! Can we have working session so that i can discuss in detail?

sure...it will be good if you can describe the issue before in details which gives me more time to prepare and discuss on possible solutions.

Sure Ankit. I have Timeseries plotted in Line chart (x-axis: timestamp of TS and y axis: temperature/pressure measure) and i want to show when event has occurred in same chart by plotting a marker for event name. 

I see, the kind of feature you are looking for is not supported in Power Bi, but we very well support this in Charts today. Please let me know what time time you are available tomorrow and we can setup a call to demo that.

Do you mean we cant plot TS and events association in one chart in PowerBI? I can connect tomorrow anytime post 2PM IST tomorrow.

@Paramale Arati It's important to note that in the event you have both a start and end date, so it cannot be displayed as a point marker. So, as @Ankit Kumar  wrote before, you can’t directly display both timeseries and events in one chart in PowerBI. But it allows you to utilise a Line chart along with a custom timeline chart, such as a Gantt chart, for example, one under another, and apply the same filters on intervals. This method can be effective if there are not too many events within the observed interval.

And that’s an example of how it looks like in Cognite Charts:

HI @Ankit Kumar, As discussed, please let me know if you have any further inputs. 

Thanks in advance!