How to get the checkboxes enabled based on the result ?

@NH_shree  

You can simply get value from InfoTable like this :

// value from SQL Query
var sqlOuputInfoTable = <<SERVICENAME>>
var averageValue = sqlOuputInfoTable.average_totalcurrent

// To get infotable value based on index
// var averageValue = sqlOuputInfoTable.rows[<<ROWNUMBER>>].average_totalcurrent

Updated script :

// Create InfoTable to store result
// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(machineStaus)
let result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
	infoTableName: "InfoTable",
	dataShapeName: "machineStaus"
});

// Calculate Average value
// Put your logic here
// var averageValue = averageValue; // For Testing averageValue will be input

// value from SQL Query
var sqlOuputInfoTable = <<SERVICENAME>>
var averageValue = sqlOuputInfoTable.average_totalcurrent
// declare variable to store machine status
// Value greater than 6 and lesser than 3, machineNotAvailable will be true by default
var machineAvailable = false;
var machinePartiallyAvailable = false;
var machineNotAvailable = true;

// change condition based on your requirement
if (averageValue > 3 && averageValue <= 6) {
	// update machine status
	machineAvailable = true;
	machinePartiallyAvailable = false;
	machineNotAvailable = false; 
}
// change condition based on your requirement
else if (averageValue > 2 && averageValue <= 3) {
	// update machine status
	machineAvailable = false;
	machinePartiallyAvailable = true;
	machineNotAvailable = false;
}

// Add updated value to result infotable
result.AddRow({
	machineAvailable: machineAvailable,
	machinePartiallyAvailable: machinePartiallyAvailable,
	machineNotAvailable: machineNotAvailable
});

/VR