How to create breakdowns on Catalog variables in Performance Analytics in ServiceNow?

[Anand78]

I am new to PA and new to ServiceNOW.

I am trying to create few dashboards for Catalog Request Items to present meaningful data.

My data segregation is in variables on catalog items.

I do not see any way to create breakdowns on Variables.

Can anybody shed some light on it or provide pointers for me to move in right direction?

[dhenslee]

I have the exact same question/issue.   Mentioning some super helpful people ive had help me in the past.... arnoud guusmathijssen adamstout

[Dennis R]

Breakdowns can be mind-bendingly complicated, but let's see if we can get you set up.

First question is, what is the variable type? The exact way to set it up will depend on what type it is.

[dhenslee]

Lol I was hoping there was an easy button.  If anandch answers, then answer his first but i'm curious for either a choice list drop down field or a reference variable field.  Ive pretty much resorted to reports for doing any reporting off of a catalog variable field.

[Dennis R]

I'm still at the office, but I'll try to post a more thorough reply tonight. In a nutshell you have to:

• Create a breakdown source for the choice list (question_choice table, I believe) or reference table
• Create an automated breakdown to map the value of the variable in the request item (sc_item_option table) to that choice or reference value.

It's hard because you have to go through like two levels of indirection to get to what you want, but it shouldn't be impossible or anything. Like I said, I'll try to post a thorough answer tonight because it strikes me as something that would be useful for the community at large. 🙂