If you want to add the field Groupname (contracted plan) to Radius to be shown on Made4Graph, run the command below on Radius:
CREATE DEFINER=`AdminDB`@`%` TRIGGER `radacct_stop_insertGroupName` BEFORE INSERT ON `radacct`
FOR EACH ROW BEGIN
DECLARE ParamGroupName VARCHAR (64);
SELECT groupname INTO paramGroupName FROM radusergroup WHERE username = new.username LIMIT 1;
IF (ParamGroupName IS NULL) THEN
SET new.groupname = 'NO GROUP';
ELSE
SET new.groupname = ParamGroupName;
END IF;
END
