How to represent timestamp dimension second to days in visual report builder?

I’ve got stuck in a problem with magentoBI visual report builder. The problem is, I have a metric with some dimensions and millions of rows where the timestamp is a dimension where we put every second generated data of every day.

Now in visual table report building, I need to see the data day-wise that they will sum up the rows where data are expressed in second and make data day-wise?

Is it possible in visual report builder? if possible How?