In a Pivot / Heatmap why am I unable to assign the required 2nd breakdown?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2024 07:13 AM
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?
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2024 07:29 AM
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...
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2024 07:37 AM
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.