Posted by lieuwe Montsma at 12:49 on Saturday 8th January 2022[link]
Am absolutely happy with the RGraph charts.
have 2 questions:
a. var scores = sheet.get('H2:K2'); Can I add a selection criteria as for example:
var scores = sheet.get('H2:K2') where score = 3;
b. can I use an URL variable as the selection criteria? Or use the URL variable as input for a graph?
thax in advance
Leo
Posted by Richard at 15:54 on Saturday 8th January 2022[link]
a. You can't add selection criteria but you can easily do that with a for() loop after you fetch the data:
var row = sheet.get('H2:K2');
// Change values that aren't 3 to null, and populate a new // array (row2) with those values.
for (var i=0,row2=[]; i<row.length; ++i) {
if (row[i] !== 3) {
row[i] = null;
row2.push(row[i]);
}
}
b. I don't know your setup so there are two possibilities I can think of. You could get the variable from the URL using server-side scripting (for example PHP). So that would change the above code to:
for (var i=0,row2=[]; i<row.length; ++i) {
if (row[i] !== <?php echo intval($_GET['myVariable']) ?>) {
row[i] = null;
row2.push(row[i]);
}
}
An example URL would be:
/foo.php?myVariable=3
Another way would be to use JavaScript:
var params = new URLSearchParams(location.search);
var myValue = params.get('myVariable');
myValue = Number(myValue);
for (var i=0,row2=[]; i<row.length; ++i) {
if (row[i] !== myValue) {
row[i] = null;
row2.push(row[i]);
}
}