MyEMS / myems

        maximum = None

        counter = 0

        current_datetime_utc = start_datetime_utc.replace(minute=0, second=0, microsecond=0, tzinfo=None)

        while current_datetime_utc <= end_datetime_utc:

            sub_total = Decimal(0.0)

            sub_maximum = None

            sub_counter = 0

            for row in rows_hourly:

                if current_datetime_utc <= row[0] < current_datetime_utc + \

                        timedelta(minutes=config.minutes_to_count):

                    sub_total += row[1]

                    if sub_maximum is None:

                        sub_maximum = row[1]

                    elif sub_maximum < row[1]:

                        sub_maximum = row[1]

                    sub_counter += 1

            sub_average = (sub_total / sub_counter) if sub_counter > 0 else None

            result_rows_hourly.append((current_datetime_utc, sub_average, sub_maximum))

            total += sub_total

            counter += sub_counter

            if sub_maximum is None:

                pass

            elif maximum is None:

                maximum = sub_maximum

            elif maximum < sub_maximum:

                maximum = sub_maximum

            current_datetime_utc += timedelta(minutes=config.minutes_to_count)

        average = total / counter if counter > 0 else None

        return result_rows_hourly, average, maximum

        weekday = start_datetime_local.weekday()

        current_datetime_utc = \

            start_datetime_local.replace(hour=0) - timedelta(days=weekday, hours=int(config.utc_offset[1:3]))

        while current_datetime_utc <= end_datetime_utc:

            sub_total = Decimal(0.0)

            sub_maximum = None

            sub_counter = 0

            for row in rows_hourly:

                if current_datetime_utc <= row[0] < current_datetime_utc + timedelta(days=7):

                    sub_total += row[1]

                    if sub_maximum is None:

                        sub_maximum = row[1]

                    elif sub_maximum < row[1]:

                        sub_maximum = row[1]

                    sub_counter += 1

            sub_average = (sub_total / sub_counter) if sub_counter > 0 else None

            result_rows_weekly.append((current_datetime_utc, sub_average, sub_maximum))

            total += sub_total

            counter += sub_counter

            if sub_maximum is None:

                pass

            elif maximum is None:

                maximum = sub_maximum

            elif maximum < sub_maximum:

                maximum = sub_maximum

            current_datetime_utc += timedelta(days=7)

        average = total / counter if counter > 0 else None

        return result_rows_weekly, average, maximum

        # calculate the start datetime in utc of the first day in local

        start_datetime_local = start_datetime_utc + timedelta(hours=int(config.utc_offset[1:3]))

        current_datetime_utc = start_datetime_local.replace(hour=0) - timedelta(hours=int(config.utc_offset[1:3]))

        while current_datetime_utc <= end_datetime_utc:

            sub_total = Decimal(0.0)

            sub_maximum = None

            sub_counter = 0

            for row in rows_hourly:

                if current_datetime_utc <= row[0] < current_datetime_utc + timedelta(days=1):

                    sub_total += row[1]

                    if sub_maximum is None:

                        sub_maximum = row[1]

                    elif sub_maximum < row[1]:

                        sub_maximum = row[1]

                    sub_counter += 1

            sub_average = (sub_total / sub_counter) if sub_counter > 0 else None

            result_rows_daily.append((current_datetime_utc, sub_average, sub_maximum))

            total += sub_total

            counter += sub_counter

            if sub_maximum is None:

                pass

            elif maximum is None:

                maximum = sub_maximum

            elif maximum < sub_maximum:

                maximum = sub_maximum

            current_datetime_utc += timedelta(days=1)

        average = total / counter if counter > 0 else None

        return result_rows_daily, average, maximum