Help with Calculation Please
I am trying to calculate the Trial Conversion Rate for our software using metrics imported each month with the following structure:
- Reporting Period (month/yr)
- Product Version (7 possible choices)
- Metric Description (Revenue, Cancellation, New Clients Added, Free Trials, Support Requests)
For a given time period, I would like to calculate the Trial Conversion Rate by dividing # of New Orders for the period by the # of Free Trials for the same period.
Since the values for each metric are not stored in separate fields - which may be a big mistake in the way this FMP file was originally structured - I cannot create a simple calculation dividing New Clients by Free Trial Requests for each time period.
I'm at a loss about how to create this calculation.
Would I be better off changing the basic structure of this file such as the simplified structure below which would make calculations somewhat simpler?
- Reporting Period (month / yr)
- Product Version
- Metric: FreeTrials
- Metric:Support Requests