Skip to main content
Solved

KPI with no value = 0

  • February 10, 2025
  • 3 replies
  • 62 views
V
Master Author
Forum|alt.badge.img+5

Hello,
I have a KPI on the headcount planning board for budget owners showing the number of open positions. 
When there is no open positions, i would like the metric to show 0 instead of “nothing to display”. 
I tried putting a ifblank is my formula but i have an error message saying it is taking too long to calculate. 
Is there any way to show 0 ? 

Thanks
Venitia

Best answer by oliverlee

Hi ​@venitiav if it’s also okay for you to show the KPI card with a blank value instead of 0, using “show empty  columns and rows” as part of your View filter option, would give you that. This makes the KPI card at least look normal instead of displaying the “Nothing to display” text. If explicit 0 is needed, I would create a separate reporting metric with less dimensions, as suggested by ​@Stef.

3 replies

Stef
Employee
Forum|alt.badge.img+12
  • StefEmployee
  • Employee
  • February 10, 2025

Hi ​@venitiav ,

How many dimensions does your KPI have? Putting in a 0 in the formula goes against best practises as Pigment is a sparse model. Putting a 0 in the formula will fill every cell. 
What you could try is converting it to text, and at the same time reducing the number of dimensions in your metric so you cell count doesn’t explode.

Kind Regards, Stef
oliverlee
Master Helper
Forum|alt.badge.img+12
  • oliverleeMaster Helper
  • Master Helper
  • Answer
  • February 10, 2025

Hi ​@venitiav if it’s also okay for you to show the KPI card with a blank value instead of 0, using “show empty  columns and rows” as part of your View filter option, would give you that. This makes the KPI card at least look normal instead of displaying the “Nothing to display” text. If explicit 0 is needed, I would create a separate reporting metric with less dimensions, as suggested by ​@Stef.

Stef
V
Master Author
Forum|alt.badge.img+5
  • venitiavMaster Author
  • Author
  • Master Author
  • February 10, 2025

Hello

Indeed  ​@oliverlee it worked by “showing empty columns and rows” ! 
Thanks very much for the hint !! 
Venitia

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement