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?
Unfortunatelly this works for the table and for the tolltip, but not for the XY Graph, which still show the dots with no values like if they were zero.
Would make a lot more sense to not take null as zero by default. Null should not be visible unless we make it visible on purpose.
Any idea on how to hide these dots?