Forum Discussion

larissaalves's avatar
larissaalves
New Member
10 years ago

COUNT FREQUENCY OF DATA

Hi, I'm new to this plataform and need help!

 

I have a table named TrackingEvent. On the column ALARM I have three different types: 1,2 and 3. On the column PRIORITY I have four types of data: high, medium, low and event. And I have occurences for different times.

I want to be able to analyse the following:

- Between 1,2 and 3, which one happens more frequently?

- Between Low, Medium, High and Event, which one happens more frequently? Can I do some percentage? Por example, low happens 4 times out of 12, so it's 33% occurence. 

- Can I calcultate de difference in time between occurences?

 

 

Thank you very much!!

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    Here's the first two. The last one there is a way to do it but it is late and my brain hurts.

     

    • CLEARIFY's avatar
      CLEARIFY
      Helper I
      8 years ago

      So where is the calculation that you used for this?

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    10 years ago

    larissaalves

     

    - Can I calcultate de difference in time between occurences

     

    In your sample data what is correct result?

    • larissaalves's avatar
      larissaalves
      New Member
      10 years ago

      I want to show the difference in time between two alarms. For example: 10 minutes, 1 minute. And I want to be able to choose the the type of alarm and the priority.