Hi,
is it possible to hide/disconnect predefined values (or zeros) from graph?
first image shows actual graph, I want it like second graph.
is it possible?
thanks in advance
explanation:
2 - add field from calculation: take your metric value that you want to hide, i want to hide -200, so I add a positive 200 value (reverse this if it’s a positive value), this will make the value zero for all metrics with a value of -200, and the rest will just be 200 less. give it an alias and replace all the fields
3 - add field from calculation: using the alias above, divide it by itself, for all other values it will divide ok, for the zero it will NaN as you can’t divide by zero…
4 - add field from calculation: rehydrate the non NaN values, by multiplying by itself again, but remember the values are still 200 more, so…
5 - add field from calculation: minus 200 (add 200 if you were hiding a positive value) so your metrics are back to their original values, replace all fields
1 Like
thank you so much Raymond