Can we show a "Group by" list and insert into Sharepoint page as Chart?

[hfDeveloper]

I am using modern SP and can insert a simple dummy list, "Employee count by department" into SP page as Chart webpart

Dummy Group by list

Title	Count
IT	5
HR	10

But it isn't productive as I prefer the "Group by" can be derive by the Chart web part from my "Employee" list

Employee List

Title (Email)	Department	Name	Other details
emp001@company.com	IT	Employee 001	...
emp002@company.com	HR	Employee 002	...

I know the workaround is to integrate with Power BI (desktop) and perform all sort of pulling and aggregation. But I would hope to only to complete the simple task within modern SharePoint Page + List + web part.

Please share your input if there is a way. Thanks a lot~

[#2]

Hi,
I guess by derive you mean to connect both WebParts. Unfortunately not all the WebParts in SPO can be connected so when you select an item of data in a WebPart you see the details on the other one.

[#3]

good day, @Juan Carlos González Martín , i can pull SP list from the Chart webpart. My problem is why can't the Chart web part provide more aggregation functions like (Count, Sum, Group By), with that we can derive more fancy charts & graphs within Sharepoint pages without the worry to integrate with PowerBI. It saved tons of effort and investment in long run.