Graph dealing with dates

[ColtE8]

Hello!

I have a graph that shows datapoints happening within a specific year. The data input from excel is in a date format mm/dd/yyyy. There are no "open" points in previous years (2020,2021,2022) and we want to remove those from the graph but we can't get the formula to work.

Right now we have:

=Right([Completion Date],4)

I told it to eliminate null values but can't figure out how to write the formula to identify null values.

[ColtE8 · Accepted solution]

I actually got this. I simply pulled in only open points, was just overthinking it.

Answer was: =if([Data_Open]>0,(Right([Completion Date],4)))