Calculated Metrics - Not calculating

Avatar

Avatar
Validate 1
Level 1
erich59882955
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
erich59882955
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
erich59882955
Level 1

12-08-2019

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct reply

146 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct reply

146 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile
Asheesh_P
MVP

14-08-2019

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

Answers (5)

Answers (5)

Avatar

Avatar
Validate 1
Level 1
erich59882955
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
erich59882955
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
erich59882955
Level 1

14-08-2019

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

Avatar

Avatar
Boost 10
Level 2
iamjasona
Level 2

Likes

10 likes

Total Posts

25 posts

Correct reply

1 solution
Top badges earned
Boost 10
Affirm 1
Validate 1
Give Back
Boost 5
View profile

Avatar
Boost 10
Level 2
iamjasona
Level 2

Likes

10 likes

Total Posts

25 posts

Correct reply

1 solution
Top badges earned
Boost 10
Affirm 1
Validate 1
Give Back
Boost 5
View profile
iamjasona
Level 2

13-08-2019

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

Avatar
Validate 1
Level 1
erich59882955
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
erich59882955
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
erich59882955
Level 1

13-08-2019

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

Avatar
Establish
Level 4
Balaji_V
Level 4

Likes

76 likes

Total Posts

70 posts

Correct reply

10 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 3
Give Back
View profile

Avatar
Establish
Level 4
Balaji_V
Level 4

Likes

76 likes

Total Posts

70 posts

Correct reply

10 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 3
Give Back
View profile
Balaji_V
Level 4

12-08-2019

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

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct reply

146 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct reply

146 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile
Asheesh_P
MVP

12-08-2019

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