Skip to main content
Solved

Need to co-relate Events with Timeseries


Forum|alt.badge.img+1

HI All,

 

I am looking to help in order to display timeseries and events co-relation in Power BI. I want to show when the event occurred in timeseries chart on specific event time.

Any inputs would be appreciated!

 

Regards,

Arati 

Best answer by Ankit Kumar

Hi, Hope we have clarified on the solution here .

We have discussed the available options and identified the best-suited solution for your needs. I have provided all the necessary information and insights to ensure a clear understanding of the proposed approach.

If you have any additional questions or require further clarification, please don't hesitate to reach out

View original
Did this topic help you find an answer to your question?

11 replies

Forum|alt.badge.img+1

HI Team, 

Any inputs would be appreciated!

Thanks in advance!

Regards,

Arati


Forum|alt.badge.img
  • Senior Cloud Architect
  • 26 replies
  • May 23, 2023

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


Forum|alt.badge.img+1

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


Forum|alt.badge.img
  • Senior Cloud Architect
  • 26 replies
  • May 24, 2023

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.

 


Forum|alt.badge.img+1

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. 


Forum|alt.badge.img
  • Senior Cloud Architect
  • 26 replies
  • May 24, 2023

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.

 


Forum|alt.badge.img+1

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


roman.chesnokov
Seasoned Practitioner

@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:

 


Forum|alt.badge.img+1

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

Thanks in advance!


Forum|alt.badge.img
  • Senior Cloud Architect
  • 26 replies
  • Answer
  • June 2, 2023

Hi, Hope we have clarified on the solution here .

We have discussed the available options and identified the best-suited solution for your needs. I have provided all the necessary information and insights to ensure a clear understanding of the proposed approach.

If you have any additional questions or require further clarification, please don't hesitate to reach out


Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2

Hi @Paramale Arati,

I hope you were able to solve the issue. As of now, I will close this thread. If you have any questions please feel free to reach out to us. 

Best regards,
Dilini  


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings