Group Date to get each Sum

Hi guys,

I would like to seek for your ideas on how I can group the dates that updates daily and then get the sum of each group date. See sample below. I have tried the tile tool but it is creating duplicate values when I added the summarize tool. Aside from that I need to specify the date in order to get the grouping. I hope you could provide me solution without allowing me to enter or specify the date manually.

busy date.JPG

I have also attached the excel file.

Thanks,

Kamen

group date.xlsx

Workflow

Date Time

Data Investigation

Accepted answers

binu_acs

@KamenRider

GroupAmount_25042024.yxmd

All comments

binu_acs

@KamenRider what is the expected output, is that some like below?

KamenRider

Hi @binu_acs

Thanks for the response. I believe that is not the results. You may base the results on the excel I have provided, the "group amount". What I did is that I added all of the amount for certain did like for the sample below. This is same for the other dates.

Please let me know if you have any questions.

Kamen

binu_acs

@KamenRider

GroupAmount_25042024.yxmd

KamenRider

Thanks @binu_acs

I think you got the grouping. Case solved.

Kamen

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703