Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Grouping and averaging

Received Response
53
Views
4
Comments
Jennlowe28
Jennlowe28 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

Grouping and averaging

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

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    So you want to group the newly created column with your calculation of the number of days between open and close date, right?

    Did you set this column as attribute or measure? If you set it to "Treat as Measure" you can define the default aggregation (average) and it will automatically aggregate depending on the other columns you use in your visualizations.

    If you want to have it both as attribute and measure simply duplicate it and set on as attribute and the other one as measure.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    Jennlowe28 Rank 3 - Community Apprentice

    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
    Jennlowe28 Rank 3 - Community Apprentice

     
        2017-10-25_14-15-50.png
    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