Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to remove zeros from the performance analytics chart

ashisht1
Kilo Contributor

Can zeros be removed in PA chart against daily time series? Snapshot below..find_real_file.png

3 REPLIES 3

Adam Stout
ServiceNow Employee
ServiceNow Employee

For this indicator, do you have the value set to store 0 if the value is null?  Normally, PA doesn't store zeros.  You could use a formula that sets the value to null if it is zero.

Pierre Agnias
Kilo Explorer

Hi team

 

Thanks Adam for your help 🙂

To avoid 0 fugure, the only way I found (with a PA indicator) is to use a time serie with column chart without display the data labels (in the widget setup)

Let empty the value for the field "Value when nil" change nothing (indicator setup in the worksheet source).
Indeed, compare to a basic report, in PA the time series display always all the intervals (day, week, month).

In alternative, either I suggest using a basic report or, with a PA indicator/widget, to use a script to set only the periods interval where the value is different than 0.

In this last case, if someone could help, I'll be interesting.

 

Pierre Agnias
Kilo Explorer

🙂