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!!
- Can I calcultate de difference in time between occurences
In your sample data what is correct result?
Proud to be a Datanaut!