I am trying to plot a graph where wanted to show the average headcount month on month. Data has a columns which contains closing headcount of the month.
The formula am trying is as follows:
(Count of closing headcount of current month + Count of closing headcount of previous month) / 2
Please help in getting the same. Dummy data is attached for reference.
