Open Forum

Like what you see? Discover the benefits of the D365UG/CRMUG Community. Learn More

1.  Blank column showing in chart

Posted 03-06-2017 02:51 PM
  |   view attached
I built a stacked column chart to show Sum of Total Margin by Est. Close Date (Month) and Product Type, but a blank column shows when I run the chart on several different views. I've filtered the chart by blanks but cannot isolate why certain opportunities are showing up and others aren't (Est. Close Date is a required field and filled in for each opportunity) - and there are even opportunities that show in the chart under one month but also show under "Blank". We use a custom table called "Opp Offerings" instead of Opportunity Products, so I might not be able to find an answer here but wondered if anyone ran into this issue with other entities as well (such as Opportunity Products)? A screenshot is attached. Thanks so much!

Meghan Edgerle
ITS Partners

2.  RE: Blank column showing in chart

Posted 03-20-2017 03:18 PM
Was the Est. Close Date always a required field in your system? I don't believe it is out-of-the-box, so you would have had to do a data back-population once you set it to required.

Meghan Deaver
Surgent Professional Education
Devon PA

3.  RE: Blank column showing in chart

Posted 03-20-2017 04:19 PM
Making a field "required" doesn't always make it so.  It is enforced via the UI only, so any auto-created records, imported, and so on, could easily have a blank in a required field.

Julie Yack
Colorado Technology Consultants, Inc.
Colorado Springs CO