In a Pivot / Heatmap why am I unable to assign the required 2nd breakdown?

elsammons
ServiceNow Employee
ServiceNow Employee

I have defined two breakdowns and both appear to be working independently, i.e. I can create a breakdown widget and select either of my breakdowns from the breakdown selector. However, when I attempt to create a Pivot heatmap widget I can pick one or the other breakdown and upon selecting one, when I navigate to the 2nd Breakdown I am unable to find and / or assign the other breakdown. Any ideas as to why this may be occurring?

 

4 REPLIES 4

Mark Manders
Mega Patron

Not sure if it is still the case, but in the past, you could only apply 2 breakdowns and a pivot already is using one, so you can't add two more. I believe there is some change on the way on this (depending on which version you are on).

Maybe these posts can clarify: https://www.servicenow.com/community/platform-analytics-forum/pa-heatmap-displays-quot-no-data-to-di...

 

https://www.servicenow.com/community/platform-analytics-forum/how-can-i-make-a-pivot-heatmap-follow-...

 


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

What I have is:
* Name: My Widget Heatmap

* Indicator: my test indicator

* type: Pivot

* Visualization: Heatmap

* Breakdown: column_1 breakdown

* 2nd Breakdown: 

 

Click Save and "The following mandatory fields are not filled in: 2nd Breakdown. 
The problem, I can't fill the 2nd Breakdown even though my indicator includes both breakdowns and both breakdowns work on their own and in Analytics Hub.

Hi Eric, were you able to solve this problem? I am facing the same issue while trying to configure one of my PA widgets i.e I'm only able to select one of the two breakdowns and the second one is simply not appearing in the reference list.

It's always best to create your own question instead of responding to an unresolved question from somebody else. That enables you to focus on specifically your issue, with your config and your instance. People coming to this post will focus on the question eslammons asked, not on yours.
Next to that: this post is over a year and a half old. Lots of things have changed since then.

 


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark