Calculated Metrics - Not calculating

Forum|Forum|6 years ago
August 12, 2019
6 replies
5958 views

This started on 9/9. A very simple metric that calculates the throughput % in our funnel by dividing submits by starts now always displays zero. I have reviewed this calculated metric and change a number of things around and it always shows zero (I've since put it back). The odd thing is the preview displays it correctly, but the report is always zero.

Is there something known that's recently wrong with calculated metrics?

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Asheesh_Pandey

It is a bug on reports and analytics, in workspace calculated metrics are working as expected.

Asheesh_Pandey

Community Advisor

Many things can go wrong here...

However If you are looking data into csv export? There was a change made in csv export data... this change was made to make it easier for customers to apply customized formatting to the exported data. To verify I would suggest to add 8 - 10 numbers after decimal values than see if you still getting zero.

Thanks,

Asheesh

- Asheesh

Balaji_V

Level 4

Hi,

Generally seeing all zeros on a calculated metric can mean one of two things:

An issue with the syntax of the calculated metric formula
One or more of the variables used do not contain data

The following are some common issues where calculated metrics return zeros:

Multiplying by a decimal without a leading zero:

          Incorrect:
                                                                                                                      [event2] * .5
                                                                                                            Correct:
                                                                                                               [event2] *0.5

Multiplying by an event that is currently not implemented:
Dividing by zero: Similar to multiplying by zero, except it shows as #DIV/0! instead.
Open parenthesis: Forgetting to close parenthesis in your formula returns unexpected results or break the formula altogether:

         Incorrect:
                                                                                                          [event3] * ([event1] + [event2]
                                                                                                     Correct:
                                                                                                     [event3] * ([event1] + [event2])

Using brackets outside variables:

         Incorrect:
                                                                                                       [event3] *[[event1] + [event2]]
                                                                                                     Correct:
                                                                                                     [event3] *([event1 + [event2])

Accidentally removing a bracket:

        Incorrect:
                                                                                                     [event4 / 7
                                                                                                Correct:
                                                                                                     [event4]/ 7

If after following all of the above troubleshooting steps your calculated metric is still not working as expected, have a supported user contact Customer Care.

Thanks,

Balaji

E

erich59882955Author

Level 2

Thanks, but none of these conditions are true. This calculated metric has been unchanged for a number of years, then started displaying zeros. The values for that go into the simple calculation are present. It looks like:

Quote Start Quote Complete QCR (Calculated metric)

244 122 0%

The CM is Quote Complete/Quote Start (1 decimal place, display as %) and again the preview in the CM will show (50%)

The above example is when i use a longer date range (0%). When I use 1 day, it's displaying the example above as .5%. Which appears to be a formatting issue. I also tested adding *100 to the CM and still displays zeros.

iamjasona

Level 2

Agreed - there is something definitely wrong with calculated metrics when viewed in the Reports area. I think it might be that the value is simply off by a factor of 100.

I have a simple "Conversion Rate" calculated metric (it might even be the OOTB metric) that is Orders divided by Visits. For a simple scenario, I have 1 order and 4 visits...and in reports, the "Conversion Rate" shows as 0.25%. Same data in Workspace and the Conversion Rate shows (correctly) as 25%.

I believe this issue started last Friday maybe - ???