Breaking news from around the world
Get the Bing + MSN extension
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I have created lots of Goals and Goal metrics ETC, and i'm creating a dashboard .. I have 2 charts, both base on Goal entity, and one using the view "My active goals this fiscal Period" and one using "all active goals this period". The views themselves work fine when viewing the data … but the charts are system charts and they contain "Todays target Percentage" -- however this seems to always show 74% and doesn't change ?
Since the data source of the chart is a view, please check this view.
Is the value of the field "Todays target Percentage" of all goals in the view all 74?
Hi Lu Hao,
Yees the view also shows all 74%. I understand that this percentage relates to the currently Percentage that we are through the current fiscal quarter. But it should be a system field calculating the % target we need to achieve today which should be different per person and different per day. In the below video at 5:06 minutes (https://www.youtube.com/watch?v=cAe3UAA2QtI&t=2422s) the chart shows a users goals, split by quarter but with accurte "Todays Target ~Percentage" .. As this is a system chart i dont think i should be editing it ... but i also don't know how to see what the calculated field is actualyl calculating as in the below screenshot the field doesnt appear to have any calculations ?
In my opinion, this may be by design.
Today’s Target (Percentage Achieved) - A system-generated expected value for percentage achieved against the target goal.
For example say Target of the goal is 100k and Goal duration is 1st November to 30th November. If Today’s date is 21th November, then projected percentage for today would be
Today’s Target (Percentage Achieved) = 100 * 21/30 = 70.00 %
Please check if your goals matches this formula.
Refer to this article:
Actually i understand what you mean now ... That makes sense. Can i ask, how do i see what the underlying calculation of that field is ?
Its formula is
Today's target Percentage = 100 * ( CurrentDate – GoalStartDate + 1 ) / ( GoalEndDate – GoalStartDate + 1)
So as long as CurrentDate, GoalStartDate and GoalEndDate are the same, then Today's target Percentage will be the same.
Business Applications communities