heat map on time of the day and day of the week

[Pragya]

I was working on the heat map and

my first dimension is

day of the week on x-axis

day([patientarrivaldate]) as [arrivalday]

my second dimension is

time of the day on y-axis

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

My aim is to get 00:00 - 00:59, 01:00 - 01:59, 02:00 - 02:59 etc for 24 hours

Measure is no. of patients arrival in the hospital

count(admission number)

any help will be appreciated.

Thanks

[Anil_Babu_Samineni]

Create field in the script and use it as

If(Hour(arrivaltime)>='00' and Hour(arrivaltime)<'01', '00:00-00:59',
If(Hour(arrivaltime)>='01' and Hour(arrivaltime)<'02', '01:00-01:59',
If(Hour(arrivaltime)>='02' and Hour(arrivaltime)<'03', '02:00-02:59', ...)))