Check in hour (C4C Analytics)

[garias]

Hi community, I hope you are all safe and good.

I need to make a report, and then a graphic, that shows the check in hour of the visits, something like this:

But I cannot find the date field nor the way to convert the check in date to just the hour portion.

Is there a way to build such graphic using an standard field or maybe a way to build the field using the check in date?

Pleas note that I need the check in hour not the programmed hour, in local time.

Best regards

Gustavo Arias

[mjveerhuis1]

Hi,

The standard Check-In Date Time.

I checked the Visit Analysis report. You might need to add an extension field in the visit of the type time that represents the hour, add it to the Visit Header in the reporting tab.

Unfortunately the check in time is not available in the workflow rules, so you might set up a rule that takes the hours from the check in data time for example 16 and puts that in the extension field.

Then if that is successful you have to update your report.

MJ