Apex Charts Data doesn't appear correct

Third party integrations
1

Hi
I have an apex chart apexchart
which is showing just 3 x columns of data
column 1 = 2 August @ 5:12 am - count 94
column 2 = 2 August @ 7:12 am - Count = 3
column 3 = 2 August 4:12 pm - count 1

My chart code is as follows:

type: custom:apexcharts-card
graph_span: 34h
header:
  show: true
  title: Lounge Motion (Count / Hour)
  show_states: true
all_series_config:
  show:
    in_brush: false
color_list:
  - green
experimental:
  brush: false
series:
  - entity: binary_sensor.is_motion_detected_radar_lounge
    type: column
    transform: 'return x === ''on'' ? 1 : 0;'
    name: Radar
    group_by:
      func: sum
      duration: 1h
      start_with_last: true

I am using sqllite and ran the following query

SELECT datetime(strftime('%Y-%m-%d %H:00:00', datetime( last_updated_ts,'unixepoch')) , + '12 hours') as dt ,  count(*)
state
FROM "states"
Where metadata_id = 458  and   substr(dt, 6, 5) = '08-02'  and state != 'unknown' and state = 'on'
Group by dt
order by state_id desc

And i am getting the following data back:

8/2/2023 16:00 1
8/2/2023 8:00 3
8/2/2023 6:00 23
8/2/2023 5:00 71
8/2/2023 2:00 10
8/2/2023 1:00 26

Can anyone help me to explain what I am doing wrong as the figures don’t tally

Cheers

Ants