Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 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 | Upcoming TechTalks
I'm trying to create a chart to display the number of incidents that are active where 'followupby' is overdue, I have started by just using the filter where the 'followupby' is 'today', and 'this-week' and the results are not as expected. Has anyone had experience using date filters?
I know I can create different views to render this into a chat, but I would like to create one view and have multiple charts.
I've worked of this as an example - https://crmchartguy.wordpress.com/2013/01/23/include-records-with-no-value-in-charts/and had a look on http://technet.microsoft.com/en-us/library/aa477320.aspx#fetchxmlconditions
This is the xml code I have so far.
<link-entity name="incident" from="ticketnumber" to="ticketnumber" link-type="outer"> <attribute name="ticketnumber" aggregate="countcolumn" alias="_CRMAutoGen_aggregate_column_Num_0" /> <filter> <condition attribute="followupby" operator="this-week" /> </filter></link-entity>
Thanks in advance
The follow code seems to be working. I changed the condition from 'today' to 'last-x-years' with the value of 99, this gives me all 'overdue' incidents.
Without further investigation, I'm assuming the 'today' condition only works with dates, not date and time.
<link-entity name="incident" from="ticketnumber" to="ticketnumber" link-type="outer">
<attribute name="ticketnumber" aggregate="countcolumn" alias="_CRMAutoGen_aggregate_column_Num_0"></attribute>
<condition attribute="followupby" operator="last-x-years" value="99" />
Business Applications communities