Nova resource page show group by result

I have category viewed log table, category table, product table, which like below.

category viewed log table

id category_id user_id created_at

category table

id name

product table

id name category_id

I want to show the viewed times of each category and the products number belong to each category in the nova resource index page. and can be searched by date rage. so something like below.

category.name    viewed times        products number            

how to make it work like this?

thank you.