Table which displays 24 hours of the day

[#1]

Hi all,

Table header should be the hours of the day and the first row should have the count of completions, second row count of signups,

I have a date in format - MM/DD/YYYY HH:MM:SS AM/PM.

I have a expression for counts : count(course_completed)

Count(user_signed)

but this should display in hour wise when i select a date through date picker.

If number of count completion in 1'O clock is 10 then it should display in column 10.

Please help over this.

Regards,

Pramod

[Kushal_Chawda]

I think first You need to create the Hour Field in script as

Hour(YourDate) as Hour

Now You can select the Particular Date & Corresponding Hour also to get the result

[#3]

Not quite sure what you want, but you could use a PivotTable, with HOUR([DateField]) as the column dimension and perhaps DATE([DateField],'MM/DD/YYYY') as the row dimension - then your two measures.

It would give you the hours of the day along the top - however, if the count in 01:00 is 10, it would display 10 in the second column - not the tenth.