Hello,
I am trying to generate a heatmap in Google Sheets to show what times the most calls come in. To do this, I need to count entries that are on a specific day of the week and in a certain time frame.
Below you will see the heatmap I am trying to fill and the form the data comes in.
Screenshot_2.png
Screenshot_3.png
Thanks!
If the call dates and call times are on Sheet2, put this into the cell C2 of your grid, then drag it across and down.
=ARRAYFORMULA(COUNTIFS(TEXT(Sheet2!$A:$A,"dddd"),C$1,Sheet2!$A:$A,"<>"&"",Sheet2!$B:$B,">="&$A2,Sheet2!$B:$B,"<="&$B2))
Next, create your heatmap which will highlight by column.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks