• Scott Mathers - 1 year ago

    This is an aspect on salesforce reporting I recently came across that was not possible with current implmentation. The Power of One solution did not solve it either. That works to get distint counts but only in simple situations. Recently I needed to report on distinct client count in programs but broken down to a sub level (funding type or client type) and it was not possible. I hope it actually comes out in a few months time.
    • Flag

  • Jenny Back - 1 year ago

    this will be so helpful
    • Flag

  • Shelley Swyer - 1 year ago

    Omg we so need this!  Thank you 
    • Flag

  • Cathal Moran - 1 year ago

    Love it, another use case, on the Tasks and events report I want to report on the number of accounts that have a task logged against them in a certain time. I don't care if account X has 50 tasks, I just want the number of accounts.

    I know I can do a cross filter on an account report, but that ties my hands in dashabord filters, as I want to be able to show in a week how many accounts had a specific task type against them.
    • Flag

  • Christian Raidel - 1 year ago

    Looking forward to use this feature.
    • Flag

  • Mathew Ventre - 1 year ago

    We could use this feature.  
    • Flag

  • Maxine Levine - 1 year ago

    Glad to see this is being built! Can't wait to try the beta.
    • Flag

  • Matt Shonkwiler - 1 year ago

    @Anusha Surepeddi - Thanks for the update!  Very exciting to see that it will be in Beta for Winter '20!

    @Lyndsay Maby - Unfortunately Power-of-One won't work if what you want to count is the number of groups (power-of-one will only show you the number of unique objects within each grouping).  Power-of-one is awesome, but it's not a viable workaround in such cases where the objects can fall into more than one grouping and you need to count the groupings themselves.
    • Flag

  • Lyndsay Maby - 1 year ago

    In the example described in this idea, I would use my Accounts Power of One field to show me the unique number of accounts with at least one "closed won" opportunity (filtering to only show close won opps). However, you are right that it would still return extra records. I typically have groupped by the Account and then hidden the details... or just show the sum of the Power of One Accounts at the top of the report or on a dashboard. But yes, when looking at the details, you'd see "too much" data. Still, for the use case described above of trying to see how many unique accounts have purchased something, I do think it should work. We do this for how many unique Contacts have an Open Opportunity, for example. 
    • Flag

  • Caleb Miller - 1 year ago

    From my own experience I can tell you that Power of One definitely doesn't work to resolve this idea, it counts records, not unique field values.
    • Flag

  • Peter Bender - 1 year ago

    (follow)
    • Flag

  • Lyndsay Maby - 1 year ago

    The Power of One definitely works; we use it all the time! I do agree that standard functionality would be great, but in the mean time, check out the Power of One: https://www.salesforce.com/video/296533/
    • Flag

  • Carlos A. Gallardo - 1 year ago

    This is great! Does the Power of One already do this? I guess standard functionality would be great rather than going with Power of One.
    • Flag

  • Anusha Surepeddi - 1 year ago

    You prioritized it and now we’re building it! Thank you Trailblazers for helping us prioritize the product roadmap. Inspired by this idea, we’re working on the following feature: Unique Row Count in Reports. Users will have the ability to summarize a column by unique and use this new "unique row count" aggregate in charts, etc. This feature will be in Beta for Winter'20 release. Learn more about Prioritization and how you can shape Salesforce products via the IdeaExchange at https://sfdc.co/IDXrGroup.
    • Flag

  • Randeep Singh Khalsa - 1 year ago

    This would be great feature. 
    • Flag