Fixed Bug in Annual Planner - Complementary Training
Fixed Bug in Annual Planner

Fixed Bug in Annual Planner

Thanks to Darrell Morgan, we have found and fixed a small bug in Annual Planner. Unfortunately the bug was affecting Athlete Profile analysis a lot.
The problem was that “Last value” was actually average of all values. Look at the two pictures below:

Bug 1

Bug 2

As you can see the aggregate function is not pulling the last value but the average off all values. I have no clue how this slipped, but I apologize to everyone for this bug!

I very much appreciate the feedback from Darrell who got Premium Membership for his help.
Since we are continuously trying to improve our products we will offer the same to everyone who find any kind of bug.
Also if you have any feedback, suggestions or compliments about our products we would like to hear from you.
Please feel free to contact our product support support@complementarytraining.net

The solution is quite simple and fortunately this bug is pretty easy to fix!

That being said, I suggest that you fix your own copy, especially if you already have plenty of data inside.
Click on the Powerpivot tab, then Calculated Fields box and finally Manage Calculated fields.

PowerPivot

 

Select “Metric last value” and click Edit.

Metric-Last-Value-360x300

Now you will see the DAX code:

DAX1

Make sure to change it to the following:

DAX2

 

Here is the code if you want to Copy-Paste it:

CALCULATE(AVERAGE(MonitoringDatabaseTable[Value]),
LASTDATE(MonitoringDatabaseTable[Date]))

And that’s it!

We are going to send a new version to everyone who bought it!
All Premium Members can download Annual Planner for Sports v2.1 for free by clicking HERE.

Once again we apologize for any inconvenience this may have caused you.

 

mm
I am a physical preparation coach from Belgrade, Serbia, grew up in Pula, Croatia (which I consider my home town). I was involved in physical preparation of professional, amateur and recreational athletes of various ages in sports such as basketball, soccer, volleyball, martial arts and tennis. Read More »
free-memeber-button
free-memeber-button

Welcome to Complementary Training Community! Forums Fixed Bug in Annual Planner

Tagged: ,

This topic contains 0 replies, has 1 voice, and was last updated by mm Mladen Jovanovic 8 years, 3 months ago.

You must be logged in to reply to this topic.