#QuestionForGroup
Hello everybody, i need help.
I have 3 columns of data:
-days date
-the quantity planted
-the quantity harvested
but
-planting takes place every year from July 1 to June 30 of the following year and so on.
-the harvest takes place every year from January 1 to December 31 of the following year and so on. the harvest is therefore delayed by 6 months.
I would like to :
-create a calculated field integrating these date ranges for each of the 2 metrics.
-create a metric that calculates the harvest/planting ratio taking into account the 6-month gap.
Thank you
LinkedIn
Twitter
