Group by reports and multienum fields

Idea created by Groupe Sugar on Jan 27, 2017
    Active
    Score15
    • frinaldi
    • KateLloyd
    • Ishani Lad

    Hello,

     

    It should be interesting to change the way SugarCRM manages the multienum field as a grouping criteria in reporting.

     

    For example, with the following example :

     

    • Record 1 - multienum field values : A, B , C
    • Record 2 - multienum field values : A, B 
    • Record 3 - multienum field values : A, B 
    • Record 4 - multienum field values : A, C

     

    What Sugar will provide if you group by multienum field and count :

    • A, B, C : 1
    • A , B : 2
    • A , C : 1

     

    What most of customers expected :

    • A : 4
    • B : 3
    • C : 2

     

    Kind regards,

    Fred