Personalized Community is here!
Quickly customize your community to find the content you seek.
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 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 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