Schedule variance in a Line Chart Widget

edelente

I'm using a variation of this formula, which allows me to sort of plot my baseline, showing roughly at level we would be complete every two weeks.

=COUNTIFS({Finish Date Column}, AND(ISDATE(@cell), @cell <= [Table Date Column]@row)) / COUNTIFS({Finish Date Column}, OR(@cell <> "", @cell = ""))

Would it be possible to add another column to my table that would list actual completion, and plot a second line in the widget to show schedule variance?

Thanks in advance!

Paul Newcome

Yes. All you should need to do is insert the new column then use the first COUNTIFS.