Expand my Community achievements bar.

SOLVED

Calculated Metrics - Not calculating

Avatar

Level 2

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

6 Replies

Avatar

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

Avatar

Level 5

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

Avatar

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. 

Avatar

Level 3

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 - ???

AA_Report_CalcMetricsIssue.png

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 2

Yes, definitely a bug and I see it has been since fixed.  The calculated metrics appear to be calculating correctly as of this morning.