Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Is grouping possible inside a column

Hi All, 
I have an different assignment groups i want to calculate which assignment group is taking more time to resolve the ticket for that i have created the difference column but how to group the rows here i have 400 rows like My Group 1, My Group2 ....My Group 404. I want to see which group is taking more time to resolve the ticket.

 

Need Help
Tips and Tricks

1 Reply

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    You need to create a calculated column either in Power Query or DAX layer to define the grouping. For example,  Mygroup 1, 2 and 404 are called Group 1 and so on or you can use UI to create groups by selecting different rows as like below screenshot. When you display the result by group then you can sum the days (Date Diff) and display which group is taking more time.

     

    Thanks

    Hari