I have an external API which return this sample JSON data representing the calls each user do, i can get up to 16K items:-
[
{
"Name": "John Doe",
"DateTime": "2024-11-01T09:00:00"
},
{
"Name": "Jane Smith",
"DateTime": "2024-11-01T10:30:00"
},
{
"Name": "John Doe",
"DateTime": "2024-11-01T10:15:00"
},
{
"Name": "Emily Davis",
"DateTime": "2024-11-04T08:45:00"
},
{
"Name": "Michael Brown",
"DateTime": "2024-11-05T09:00:00"
}
]
Now i want to update an excel sheet with the those data:-
1) Count the number of calls for each user from 6am-8am
2) Count the number of calls for each user from 8am -10am
now i can all the items >> so how i can group the data by Name & Date/time then get the count? the excel sheet that i need to populate will have those main columns (highlighted in green) that need to be populated by the flow:-
Thanks in advance for any help.