Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I'm not sure if this is possible, but I want to create a chart from an option set field, to use in a dashboard.
At the moment we can select if an attendee attended the event "yes" or not "no". I want to create a chart that shows the number of attendees and then the actual number. I'm guessing a bar chart is easiest, as I want to show this over a number of events, not just one.
Is their a way to get the system to recognize the "yes" and sum count those. At the moment it only recognizes it a line level, so counts regardless of option. I need to be able to get the total number and then only the yes in a graph.
Or is my only option to export the data to excel and then try to push a chart back in? If so what is the best way to do this?
You can check this approach and hope this works for you. You can create a view with the filter criteria to display only attendee which are attended the event.
Then you can use that view to design your chart, here we displayed Closed leads count for Rating “Cold” (Option set).
Then select Option Set field on the X axis (Horizontal axis field) and select the newly created view as below.
Business Applications communities