Breakdown on Metric Instance Value field

[andersbogsjo]

Hi!

We have a Metric Definition to measire Fild value on RITM stage. 
The requirement is to have a Breakdown on the Value tjhat is the RITM Stage. And value is a string field.

I have a Databaseview for Ritm metric

It seems to that I an unable to collect trhat as a normal breakdown, so is PA script the solution  or Manual Breakdown?

Anyone has experience of this?

@Adam Stout how would you solve this regarding to the Office Hours 'Reducing scripts.....'

Regards

Anders

[Adam Stout]

This should be supported natively (no scripting or anything special).  Just create your breakdown on sys_choice (like you would for the normal RITM table) and then map the metric instance field "Field value" for the breakdown.  This stores the actual value for the choice which Performance Analytics will map to the sys_id in the background.

You probably want to create a requested_item_metric view, but here is what the mapping looks like for incident metrics:

[andersbogsjo]

Hi Adam!

I seem not to get this to work as I want.

I have used the OOTB Breakdown Stage, with OOTB Breakdown Source RequestedItem.Stage and then made the Breakdown mapping to Field value on the Database view sc_req_item_metric.

I have the then made a Workbench Widget with Main Widget Indicators on Duration (which I have made of Bucket groups)

But when I then look at the Widget and it's breakdowns for stages I seem not to get the Field values as expected (look below) - Leverans =delivery and 'Väntar på godkännande = waiting_for_approval

And if I look at the Records there are a lot more different Field values and I don't understand why the Breakdowns doesn't shows the correct Field values?

Hope you can follow me - and have some suggestion where I go wrong?

Regards

Anders