Difference between Row-wise Computation and Aggregated Computation
Row-wise Computation
What it does: Row-wise computation applies the custom metric to each row in the dataset. This means the metric will be calculated separately for each data point or entry in your report.
When to use it: Use Row-wise computation when you want to perform calculations on individual data entries. For example, if you’re calculating profit per user or conversion rate per transaction, Row-wise computation will give you precise results at a granular level.
Example: If calculating a metric like revenue per product sold, the computation will happen on each row representing a product sale, giving you specific revenue numbers for each sale.
Aggregated Computation
What it does: Aggregated computation, on the other hand, performs the calculation after grouping or summarizing data. Instead of computing values for each row, it aggregates the data (e.g., sums, averages) and then applies the custom metric to the aggregated result.
When to use it: Choose Aggregate computation when you want a summarized view of your data. This is ideal for metrics like total revenue, average profit across all transactions, or overall customer retention rate.
Example: If you're calculating total revenue per region, the metric would aggregate the sales data by region first and then compute the overall revenue for each region.
How to Set Up Custom Metric Computation in Revlitix
Introduction
Revlitix allows you to create custom metrics by defining your own conditions and computation types. Custom metrics can help you tailor reports to specific business needs by computing KPIs based on your unique criteria. Follow these steps to set up custom metric computation.
Steps for Setting Up Custom Metric Computation
Step 1: Access Integrations
Begin by navigating to the Integrations section in Revlitix.
Step 2: Access KPIs
Click on KPIs to proceed.
Step 3: Select Custom Metrics
Choose Custom Metrics from the list of available options.
Step 4: Add Fields
Click on Add Fields to start defining your custom metric.
Step 5: Choose Custom Metrics
Click on Custom Metrics to begin setting up your metric's structure.
Step 6: Define Conditions
Add the necessary conditions for your custom metric by specifying what data points or criteria should be included.
Step 7: Select Computation Type
Choose a computation type:
Row-Wise: Computes the metric based on individual rows of data.
Aggregated: Computes the metric across multiple rows, summarizing the data.
Step 8: Create Custom Metric
Once you've defined the conditions and selected the computation type, click Create to complete the setup.
Conclusion
Custom metrics in Revlitix allow you to compute KPIs tailored to your specific business needs.
Whether you're calculating row-wise or aggregated metrics, this feature gives you the flexibility to track performance in a way that best suits your objectives.