Forum Discussion
Calculate Alarm Rate
I have a dataset of equipment alarms and I would like to be able to view the alarm rate? This is the total number of alarms that have annunciated per hour, averaged across the entire month. See example
Example
Hi AnnaTristan98 ,
I hope the attached PBIX file will help you.Please go through the PBIX file.
Thank you.
12 Replies
Data set example Attached is a data set example
Hi AnnaTristan98 ,
Thank you for reaching out to Microsoft Fabric Community.
Sorry to inform you that we are not able to access the Dataset example.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided, so that it will be helpful for us to solve the issue more effectively.Data Set Example See attached data set example. Here is a a data set example of alarms that should be analyzed.
The screen shot in my origional message is what I want the visual to look like. I need the total of alarms per hour, averaged accross the entire month.
In addition I want the performance levels color coded less then or equal to 6 is green, less than 30 blue and greater then or equal to 30 is orange. this is the second screenshot in my origional message.
Any help?
HI AnnaTristan98 ,
Sorry for the delay in Response..!!
Working on the issue, will let you once issue got resolved.
Thank you.
Hi AnnaTristan98 ,
I have created PBIX file using sample data.Please go through the attached PBIX file for your reference.If this doesn't help request you to share the sample data so that it will be helpful for us to solve the issue more effectively.
Thank you.
Hi AnnaTristan98 ,
I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.
Thank you.
Hi AnnaTristan98 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
I am trying to add this to my model but am having some issues
need the average number of alarms per hour not over total hours? I think thats what my problem is with your example
Hi AnnaTristan98 ,
I hope the attached PBIX file will help you.Please go through the PBIX file.
Thank you.
Hi AnnaTristan98 ,
I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.
Thank you.
