Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
PFA
I have question to ask you. On the attached sample data, I have got 3 fields. I have the following conditions:
Issue Priority = 'Major' and Issue Status = 'Pipeline' .So what I want to calculate is count the number of the previous condition when the Date = '2018-10-01' and then from the Issue Creation Date check the difference of 30 days.
i.e. Date - Issue Creation Date (2018-09-01). So give me the number of these and in this case = 1.
So assist with this.
Thanks