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
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
Hello
Indeed
Thanks very much for the hint !!
Venitia
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.