Grouping and averaging

Question

Summary

Content

hello! I am new to all of this, and would like to get some assistance on how to show a visualization to my director that would show our teams SLA metrics. On-time, break, and what the trend is. So for example I have an excel sheet that has the assignee, the date the incident was opened, the date it was closed, and how long until it breaks SLA. I have created a calculation to show how many days it was open using the timestampdiff function using the interval days, closed dates, and opened. it worked and I now have a new column. Now I am showing my assignees and the length of time they have incidents open, and it is showing each individual incident. I want to group it by assignee and average their days open so I can show 1 - SLA break by user and 2 - Average days each a user has an incident open.

I am unable to group and I am unable to get an average for each assignee. Is this possible to do?

Thank you!

Jenn

Gianni Ceresa · Answer

The change "attribute" / "measure" is just a click, depending what the calculation is based on etc. it sometime doesn't see it as a possible measure directly.

What do you exactly mean by "first column grouped" ? If you want to group the "Assignee"  you will need to give it a logic on how to group them.

If "first column" was referred to another one you better use the name of columns of your screenshot so we all see and understand the same thing

Jennlowe28 · Answer

Yes, 'Assignee' is the first column. The third column 'Length Open' is what I am trying to average. I will create the logic to group. Thank you so much for your assistance. I will also let you all know how this works out!

Thank you!!

Jennlowe28 · Answer

I am trying to get the first column grouped. I am trying to get the third
column averaged by the group from the first column. All the data is Attributes
so I need to change my length open to Measure but the others are not measures
so they would stay the same, I believe. I am not sure why it did not
automatically provide it as a measure when it was a calculation. But again I am
new so I could have made a mistake there. I am learning this via online blogs
and discussions so please forgive me if I seem to not be understanding.

Thank you for your help