Min, Median, mean and Max duration of the assignment group with interactive date filter

[rubesh_u]

Does anyone have any idea on how to implement this in PA (or) Platform basic reporting?

I have created trend box like this but the customer is asking the same table format with Date Range filter.

(Note: I'm using metric_instance joined case table for reporting and duration monitoring)

[lauri457]

You can do a pivot table on the database view, median is not available for reporting so I suppose you'd need to create a calculated field on the database view that would store the duration in a more coarce unit than ms and then display that somehow. I only have access to platform analytics but the idea is the same with a report and an interactive filter.

However I'm not sure I understand purpose of measuring min max in assignment group duration. I'd recommend looking into SLAs, SLA breakdowns and reassignment counts. With SLAs you can set a target and then with breakdowns you can see who contributes to not hitting that target.

[rubesh_u]

Hi @lauri457 

I think field creation is not possible in database view. I should be creating that field on target tables but I don't want that because my table is metric_instance.

[lauri457]

Sorry I was thinking of function fields not calculated fields but on second thought they would not help anyway.

I would probably try to convince the stakeholder to stick to the boxplot. The pivot table is the closest what is achievable easily/OOB or you could calculate the aggregate table in a remote table. It would be simple enough to create a custom widget like above but is it worth it just because one person can't read a graph. Especially when the migration to platform analytics is going to happen sooner or later. 

It's always good to understand why stakeholders are stuck on certain ways of displaying data etc. it might be that you can get them the information they need in a better way.