Replace zero values by 0

  • What Grafana version and what operating system are you using?
    Grafana v10.1.4 (a676a96d91)

  • What are you trying to achieve?
    Replace zero values by 0
    I have different values A/B/C for examples. The issue is when doing something like ($A||$B)&&($A||$C)&&($B||$C) and for example A has no value at one time, nothing is returned.

  • How are you trying to achieve it?

  • What happened?
    when one value is NULL, nothing is aggregated

  • What did you expect to happen?
    having a value each time

  • Can you copy/paste the configuration(s) that you are having problems with?
    ($A||$B)&&($A||$C)&&($B||$C)

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No error only missing data

  • Did you follow any online instructions? If so, what is the URL?

welcome @jeremiemt

What is your data source?

Influx DB

your title says: Replace zero values by 0

You also say

and then

So which one is it? And can you share a screen capture?

Thanks




Thanks for helping. I’ve attached A (p11), B (p12), C (p13) and P (($A||$B)&&($A||$C)&&($B||$C))

My target is to have a value for on each time slot (like 6:10 or 6:40) who are empty now despite p11 has a value.

Hope it’s more understandable now.

1 Like

Is there someone that could help ?

Thanks in advance :slight_smile:

you can use a transformation:

Thank you for feedback.
I’ve tried your suggestion (and all other combination without success).

Did I forget something ?
I’ve tried to do a transformation on P series, using same config that you did but it removes everything.