# Alarm Event Trending

**URL:** <https://forum.inductiveautomation.com/t/alarm-event-trending/22335>\
**Category:** Ignition\
**Created:** [February 4, 2019, 10:08pm UTC](https://forum.inductiveautomation.com/t/alarm-event-trending/22335 "2019-02-04T22:08:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kevin.jones](https://avatars.discourse-cdn.com/v4/letter/k/e9c0ed/32.png) [@kevin.jones](https://forum.inductiveautomation.com/u/kevin.jones)\
**Post date:** [February 4, 2019, 10:08pm UTC](https://forum.inductiveautomation.com/t/alarm-event-trending/22335/1 "2019-02-04T22:08:37Z")

</div>

Hello all,

I have numerous alarming events happening and wanted to show trends of particular alarms over time to see if improvements are reducing the frequency of particular issues. I’ve figured out a query that gets me the number of instances per time period (eg day) of a specified alarm - just simple date and count columns, eg:

2018-11-15 3  
2018-11-17 1  
2018-11-18 7  
2018-12-08 1  
2018-12-09 1  
2018-12-10 2  
2019-01-06 4  
2019-01-07 14  
2019-01-09 3  
2019-01-23 1  
2019-01-24 1

I wasn’t sure where to go from here and what component would be easiest to configure to show this time based data. I’ve got a screen with a drop down with all the alarm events and a date/time picker to specify the range (eg last week or last 6 months) but not sure how to chart the results. I just want a simple line or bar chart that shows the number of occurrences each day of the specified alarm during the specified period. I don’t want to make this over complicated but I’m not seeing a simple way to achieve this but then I’m not very good with the various charting options!

Thanks in advance for the suggestions!

Kevin

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [February 6, 2019, 1:39pm UTC](https://forum.inductiveautomation.com/t/alarm-event-trending/22335/2 "2019-02-06T13:39:11Z")

</div>

If you’ve got the query made that can pull out the data, I would make it a named query with a parameter(s) to pull it by date range(start/end dates, number of previous days). Once you have that you should be able to bind that named query to a Chart’s ‘Data’ Property.

If you choose to use a drop down and depending on how your query is written, you may need a custom property or two on the component or on the window to have the dates calculated for the query to grab.