use test;

drop table if exists wtemp;

create temporary table wtemp (
  dir   double,
  val double,
  color varchar(255), 
  label varchar(255)
);

-- the data labels
-- 0 to 100% = 270
-- 1% = 2.7
insert into wtemp
  values
    (225, 78,  'rgb(0,0,0,0)', '0'),
    (225+ (20 * 2.7), 78,  'rgb(0,0,0,0)', '20%'),
    (225+ (40 * 2.7), 78,  'rgb(0,0,0,0)', '40%'),
    (225+ (60 * 2.7), 78,  'rgb(0,0,0,0)', '60%'),
    (225+ (80 * 2.7), 78,  'rgb(0,0,0,0)', '80%'),
    (135, 78,  'rgb(0,0,0,0)',  '100%')
;
 
insert into wtemp
-- this line can be used for testing:
-- select 
--   (((75 * 270.0)/120.0) + 225.0) % 360, 75, 'scarletred', null

 select 
   (((rh * 270.0)/100.0) + 225.0) % 360, 75, 'light red', null
   from raws_bl
   where gmt = (select max(gmt) from raws_bl)
;


plot radarchart
  length, direction, color override, datalabels
  with
    note " "
    note "Relative Humidity"
    font 'sans serif' plain 14
    zerobased
    no labels y
    no labels x 
    scale x 225 135 13.5
--    page 0 0 300 300
    scale y 0 75 25

    framecolor very light gray
--    background very light blue
    page 0 0 230 180
    frame 50 15 160 155
select val, dir, color, label
  from wtemp
;