Customer Engagement & Dynamics CRM Forum

 View Only

  • 1.  Top X Charts and criteria for null value inclusion

    TOP CONTRIBUTOR
    Posted May 11, 2022 08:54 AM
    I have a chart that is set to show Top 15 by a currency column.
    If there is 0 or no value in the column, items are still being returned.
    I was asked what is the criteria for selecting these items and what sort is being applied to them.
    I was stumped - anyone any idea?

    ------------------------------
    Donal McCarthy
    BrightWork 365 Solution Architect
    BrightWork
    Galway
    ------------------------------


  • 2.  RE: Top X Charts and criteria for null value inclusion

    SILVER CONTRIBUTOR
    Posted May 12, 2022 06:54 AM
    If you create a list view and include this currency column, can you then try sorting on that column? If you cannot sort on it, that will be your indicator as to the problem. If unable to sort it is likely a calculated field based on another child entity column that is either a roll up or calculated field(there is a depth limitation on these types of columns), and if this is the case your chart can't apply a top x to the column. 
    The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.



    Original Message


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