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?

 

2 REPLIES 2

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.