Hello I have a data that contains all the cases submitted and their submission date and in another column it has the approval date which can be in another date/year. I am trying to get the conversion rate (approvals/submissions) for each month, because of the timing they might not happen in the same month.
A pivot table fails to do this since it only has counts it under the same period, but a count if formula is able to do this but I am having a hard time to recreate this on DOMO.
I am trying to recreate the green area