Forum Discussion

Lewis_Beard's avatar
Lewis_Beard
Icon for Expert rankExpert
17 days ago
Solved

Do widget expressions support if/then value substitution?

A user has a need to treat zero values on some jitter graphs as if they were NULL, and not roll up into some averages on a widget. I know that I can add a complex datapoint to the datasource, or clon...
  • Mike_Moniz's avatar
    Mike_Moniz
    17 days ago

    If I understand you correctly, and you didn't mention the type of widget, but you can try making a Virtual Datapoint in a graph widget (and set the real datapoint to "do not display") that looks something like this (untested):

    if(le(MyDatapoint,0),unkn(),MyDatapoint)

    That should have the graph not show any values that are 0 or less. Virtual Datapoints use the same expressions as Complex DataSources.

Mike_Moniz's avatar
Mike_Moniz
Icon for Professor rankProfessor
11 days ago

As far as I know, you can't just have an empty value in the table or have the table exclude rows based on their values.

One trick that I've used in the past where I want to default-sort values backwards, is to make the numbers negative. So 100 shows up as -100, 1000 shows up as -1000, etc. then just tell users to ignore the (-) symbol. Messy but may help.

Also if you want to point out that these gig interfaces are actually only running 100mbit is a problems, perhaps you want to alert on that situation then use the NOC widget to show that.