The first and last options may work. For the first option, you could Synchronize the axes so that it lines up accordingly. The last option may work by writing an if statement that defines the date ranges and what should happen to the values if it does not fall in the specified date range.
Would it be possible to post the workbook (twbx file) or sample workbook?
Thanks Tracy. I've attached a sample workbook.
I'd like to add +-2% savings lines to the CUSUM chart. The % savings would be relative to the baseline year's consumption (for now, I could just manually update the constant.)
I'll have a go at the first and last options. Any Tableau guru suggestions would be much appreciated.
CUSUM Help.twbx.zip 84.6 KB