publish cr by hour view