In aggregated stats the chart looks weird during April 12th

[bartwr]

DO: Fix the cause and regenerate the chart.

[bartwr]

For CHECK, Felyx we fix the data by running the following query. This will end 398 duplicate rentals.

UPDATE
park_events
SET end_time = '2022-04-11T15:00:00'
WHERE end_time is null
AND bike_id IN (
    SELECT bike_id                                                                           
    FROM (SELECT bike_id, COUNT(*), max(park_event_id) as exclude_park_event_id
        FROM park_events 
        WHERE end_time is null group by bike_id) AS q1 WHERE count > 1
)
AND park_event_id NOT IN(
SELECT exclude_park_event_id                                                                           
    FROM (SELECT bike_id, COUNT(*), max(park_event_id) as exclude_park_event_id
        FROM park_events 
        WHERE end_time is null group by bike_id) AS q1 WHERE count > 1
);

[bartwr]

Als we nu een query draaien als:

SELECT * FROM park_events WHERE 1=1 AND system_id = 'check' AND end_time IS NULL AND start_time <= '2022-04-11T15:00:00';

dan zijn er nog steeds 34 voertuigen van CHECK met startdatum 10 of 11 april en geen einddatum. We gaan de UPDATE-query straks nog een paar keer. (Dit omdat sommige scooters nu gereden worden, die worden dan niet meegenomen in de query).

[bartwr]

We moeten de grafiek nog hergenereren. @sven4all Kun jij de geaggregeerde data van 2022-04-09 tot 2022-04-28 kunnen hergenereren?

[sven4all]

We wilde eerst nog even wachten totdat gosharing data definitief goed is. Maar nu toch alvast doen?