Watch a 3.5 minute instruction video
New with the Shinobi template beta (located under the tab Reporting - Templates (beta)) is the ability to create your own custom calculated fields to be able to fully support all of your specific client needs in your reports.
- Begin by adding a data widget to your template, and add all data sources to your widget that you wish to use in your custom calculated metric.
- Click on the "+ Add Custom" button to begin configuring your custom field:
Give your custom calculated metric a name, and select from the "Display As" drop-down to determine how this metric should be displayed in your widget:
Under the "Insert Metric" section, select the data source and the metric that you wish to add to your formula, and click on the "Insert" button to add the metric.
Select the operator that you wish to add between each of your metrics in your formula, and continue to add your metrics that you wish to use in order to create your calculated field:
You can optionally include a constant number in your formula, if desired (add a custom markup per lead, for example), and you can also use the "Row number" as a metric in your formula. The Row Number is an integer numeric value based on the number of rows being included with each custom calculation.
As you continue to add metrics and operators into your custom calculated formula, the formula will be updated as you go. When you are finished building your formula, click "OK" to add it to your data widget.
Is it possible to filter a custom metric within the custom metric menu? For a client I want to calculate the funnel flow. However, I am having trouble executing this in Ninjacat. I need to divide an event with a goal. The only problem is that the metric 'total events' is not the one that I need but a sub event (read event category/action) that needs to be divided by the microconversion (goal) in the step before.
Article is closed for comments.