Pivot Visualization - Show All Priority Values Even When Count is Zero

[prakharmahe]

I am working with a Data Visualization (Pivot visualization) based on the Incident [incident] table.

The pivot is grouped by Priority, and it displays only those priority values that have records. For example, if there are no incidents with Medium (Priority 3), then that priority does not appear in the pivot header at all.

My requirement is to display all priority values (Critical, High, Medium, Low) in the pivot header, even when the count for a particular priority is 0.

Has anyone implemented this requirement in Data Visualization / Platform Analytics? Is there any configuration, indicator setting, breakdown option, or workaround that allows showing all choice values regardless of whether data exists for them?

Example:

Current Output:

High Low

10

5

Expected Output:

Critical High Moderate Low Planning

0

10

0

5

0

Any suggestions would be appreciated.
@DrAG 

[Ankur Bawiskar]

@prakharmahe 

nothing available out of the box that forces all choice values to appear when their count is 0

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@prakharmahe 

do you require any further help?

[prakharmahe]

Yes @Ankur Bawiskar 
Please refer to this question -> How to group data by Month instead of Created Date... - ServiceNow Community