Display "NA" in chart if channel doesnt exist

[Durai26]

Hi,

I made a report template to plot the channel in 2D Axis system.

If Speed channel doesnt exist or Speed channel has "NOVALUE" then, want to display "NA" in the same chart. How to achieve this?, need some suggestion.

Regards,

Durai

[gsklyr · Accepted solution]

I attached an example TDR layout.  There is a chart and a text object.  When channel "Speed" exists in group 1, then the text is empty.  If you remove "Speed" from group 1 or rename it, the chart clears and there is a giant NA (make sure to refresh the chart after changing stuff in data portal).

I achieved this using iif() function in the text object and attached the screenshot below (but you can also see it in the TDR)

[Durai26]

Hi gsklyr,

Thanks a lot, it worked.

[Durai26]

Hi gsklyr,

I got into new problem. Your suggestion really worked good with one channel.

Now I have a "Speed" channel and the limit value in a chart.

when channel exists,

When channel doesnt exists,

when channel doesnt exist, we got "NA" but it still plot the "limit" which is constant value. How to avoid the limit curve to reflect when channel doesnt exist.

need to achieve without script.

regards,

Durai