Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Chart - Show count of non-empty

  • 1.  Chart - Show count of non-empty

    Posted Aug 15, 2019 12:00 PM
    I want to do a very simple chart displaying 2 values:

    1. Count of records where Field X does not contain data
    2. Count of records where Field X contains data (this should not be broken down by the field value)

    I set up a simple bar chart using Aggregate 'count:All'

    This is what my chart currently returns
    Blank: 34
    Dan: 1
    Joe: 3
    Mary: 5
    Kate: 7

    What I want to see is
    Blank: 34
    Non-Blank: 16

    I've tried to upload an image but it keeps timing out so apologies for that.
    Any assistance much appreciated.

    Regards,
    Sean

    ------------------------------
    Sean O Malley
    AIG
    ------------------------------


  • 2.  RE: Chart - Show count of non-empty

    GOLD CONTRIBUTOR
    Posted Aug 15, 2019 07:18 PM
    I don't think that's possible OOB. You'll likely have to resort to PowerBI or Excel for this.

    ------------------------------
    Sissy Bottcher
    Business Process Innovation Specialist
    Dynamics 365 for Sales Enterprise (Online v.9)
    San Diego CA
    ------------------------------



  • 3.  RE: Chart - Show count of non-empty

    SILVER CONTRIBUTOR
    Posted Aug 16, 2019 07:47 AM
    ​Hi Sean,

    it should be easy to set this up by changing the XML file..

    have a look at this similar filtering of a chart..
    https://crmchartguy.com/2015/06/21/compare-this-year-to-last-year-with-a-dynamics-crm-chart/

    there's a lot of great tips crmchartguy's pages. There's also a great product in the XRMtoolbox where it's easy to edit the XML.

    ------------------------------
    Lars Petersen
    CRM Manager - Jyske Finans
    Jyske Bank Group
    ------------------------------



  • 4.  RE: Chart - Show count of non-empty

    SILVER CONTRIBUTOR
    Posted Aug 16, 2019 08:44 AM
    Hi Lars,
    Did you hear that with the UI, you are no longer going to be able to modify the xml? Our IT Partner told us that this was not users were no longer going to be able to modify the XML on charts.

    ------------------------------
    Sydney Silbar
    CRM Business Analyst
    Milwaukee Tool Corp.
    Brookfield, WI
    ------------------------------



  • 5.  RE: Chart - Show count of non-empty

    SILVER CONTRIBUTOR
    Posted Aug 16, 2019 09:12 AM
    Hi Sydney,

    No i haven't heard that, Do you have more details? are they just moving it away from the front, or...

    I've seen that my previous XML changes to charts in the Classic UI are now begining to look better in the new UCI. ​they are actually working as expected, just not as clean but they show the data correctly.So you are able to make changes to the XML and use it in UCI, with some adjustments.




    ------------------------------
    Lars Petersen
    CRM Manager - Jyske Finans
    Jyske Bank Group
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role