Plot a with given starting and end number

[Anonymous]

I have a table like this. I would like to plot a straight projection line using the number of clicks goal. Is there any easy way to do this?

campaign	start date	end date	Number of clicks goal
google ad	1/1/2020	12/31/2020	1000

Thanks,

[Greg_Deckler · Accepted solution]

Like a straight line as in horizontal or a straight line going from 0 to your goal?

Either way, you will need to use something like GENERATESERIES to create a table between your start and end date. Then if you want a horizontal line every day gets your goal value. If you want it to be from 0 to goal, divide your goal by the number of days between your two dates and multiple by the number of days from your beginning date.