Heat Map for time of day - day of the week

[Pragya]

I was working on the heat map to calculate

no. of patients for time of the day and day of the week so

my first dimension on x-axis are days of the week

day ([patientarrivaldate]) as [arrival day]

my second dimension on y-axis are time of the day

hour([arrival time]) & ':00-' &hour([arrival time]) +1&':59' as [arrival time]

I want it like  00:00 - 00:59, 01:00 - 01:59, 02:00 - 02:59 for 24 hours

No . patients as measure

count (admissionnumber)

Please advise

[Pragya]

I have also attached the work document with screenshots of what I am getting from my query and what am I looking for in the heat map.

thanks