Skip to main content

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

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.


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.


Hello

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


Reply