# Frequency fault list

**URL:** <https://forum.inductiveautomation.com/t/frequency-fault-list/17920>\
**Category:** Ignition\
**Created:** [May 4, 2018, 7:13am UTC](https://forum.inductiveautomation.com/t/frequency-fault-list/17920 "2018-05-04T07:13:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dgoetschalckx](https://avatars.discourse-cdn.com/v4/letter/d/67e7ee/32.png) [@dgoetschalckx](https://forum.inductiveautomation.com/u/dgoetschalckx)\
**Post date:** [May 4, 2018, 7:13am UTC](https://forum.inductiveautomation.com/t/frequency-fault-list/17920/1 "2018-05-04T07:13:45Z")

</div>

So i already got a list of how many times and how long the fault took place. I want to sort them by frequency and not display the ones that do not occur at that moment. is there an easy way to do that. to count and time the fault i used a calculation query. thanks

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/996e6125fbff9caf98a431511ce4252374d5163a.PNG)

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [May 4, 2018, 12:59pm UTC](https://forum.inductiveautomation.com/t/frequency-fault-list/17920/2 "2018-05-04T12:59:35Z")

</div>

If you download the Alarm Analysis template from the cloud templates you can see the queries they use.  
One of them is Alarm frequency.

---

<div class="post-metadata">

**Author:** ![dgoetschalckx](https://avatars.discourse-cdn.com/v4/letter/d/67e7ee/32.png) [@dgoetschalckx](https://forum.inductiveautomation.com/u/dgoetschalckx)\
**Post date:** [May 7, 2018, 8:14am UTC](https://forum.inductiveautomation.com/t/frequency-fault-list/17920/3 "2018-05-07T08:14:12Z")

</div>

the alarm analyses works in the normal window but i’m working report. so it’s a different i think.

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [May 7, 2018, 11:43am UTC](https://forum.inductiveautomation.com/t/frequency-fault-list/17920/4 "2018-05-07T11:43:16Z")

</div>

Not really, you need to look at the queries and how they are coded.  
Then you can adapt the queries and use them in your report as a datasource.

---

<div class="post-metadata">

**Author:** ![dgoetschalckx](https://avatars.discourse-cdn.com/v4/letter/d/67e7ee/32.png) [@dgoetschalckx](https://forum.inductiveautomation.com/u/dgoetschalckx)\
**Post date:** [May 14, 2018, 6:47am UTC](https://forum.inductiveautomation.com/t/frequency-fault-list/17920/5 "2018-05-14T06:47:24Z")

</div>

i am not really good with the program, and i don’t understand what is written there.  
What i use now is the "tag calculation query’ to count how many times the fault was active.  
i don’t know how i can link the query from Alarm frequency to that.