I have a table of monthly performance metrics that includes the following fields:
- Reporting_Period (Date)
- Metric (value list of 5 possible Metrics including Revenue, Free_Trials, New Customers, Cancellations and Support Requests)
- Value: (number)
- Product_Version (value list of 10 possible products)
I am trying to calculate "ConversionRate" by dividing the number of NewCustomers each Reporting_Period by the number of Free_Trials each Reporting_Period..
Because the metrics are stored as attributes rather than separate fields, I'm having a hard time figuring out how to calculate the ConversionRate for each Reporting period. Is there a way to do this with my current structure or will I need to move the values for each Metric into separate fields? e.g. each record has separate fields for Revenue, New Customers, etc.