When using a table as input to xy chart empty Y values are shown as 0. My question is how to not show the values that are empty in the chart?
P_MW = X value. the other column is the Y value.
there is a transformation you can use, filter data by values, you can exclude nulls, 0 values etc.
2 Likes
Hi, we tried with this, but it doesn’t work. Can it be because it expect all values to be 0 in a serie?
@sowdenraymond I’ve got a similar use case, but my problem is that turning on a transformation excluding null values from one series excludes that entire row, not just the series with the null value.
Any suggestion on how to exclude only data points w/ null values while including other fields in the same row?
In the attached screenshot, we want to include the response field always, and only plot data in the right most columns when not null. All the right most columns do is duplicate the response data as a means to highlight certain data points on the plot.
you could use a value mapping to change the value from null to NA or something more descriptive instead of hiding it?