Get top 10 averages

[bartwelvaarts]

Hi community,

I have the fields ‘group’, ‘ticketnumber’ , ‘timeopen’. I want to create a bar chart with all the groups. The bar should reflect the average of timeopen for the top 10 longest open ticketnumbers for each group. Someone any idea how to do this?

[TauseefKhan]

Data Fields:

group: Department A, Department B, etc.
ticketnumber: 1001, 1002, 1003, etc.
timeopen: 5.2, 7.3, 9.1, etc.

Bar Chart Setup:
Dimension: group
Measure:

Avg(
Aggr(
If(Rank(Sum(timeopen)) <= 10, Sum(timeopen)),
ticketnumber, group
)
)
Result:

The bar chart will show each group on the X-axis and the corresponding average timeopen for the top 10 longest open ticketnumbers on the Y-axis.

****Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.*******