Sort a table by measure values
Replace ‘measureId’ with the technical id of the measure object you want to sort by
Sort a table by measure values Read More »
BASICS KB PAGE
Get dimension ids in specific rows and write them to a text box
In this example the script is placed in the button, it returns the dimension id from specific rows in the table and writes them to the textbox The top button retrieves the dimension id from row 0 & writes it to the text box: Text_1.applyText(“Row dimension: ” + rowDims[0]);The Second button uses exactly the same
Get dimension ids in specific rows and write them to a text box Read More »
Retrieve a measure name and write it to a text box
In this example the script is placed in the button, it returns the measure name from the table and writes it to the textbox
Retrieve a measure name and write it to a text box Read More »
Write the Coefficient of Variation to a text box
In this example the script is placed in the button, it returns the Coefficient of Variation from the resultSet and writes it to a text box
Write the Coefficient of Variation to a text box Read More »
Retrieve the average value from a Resultset and write it to a text box
In this example the script is placed in the button
Retrieve the average value from a Resultset and write it to a text box Read More »
Retrieve the lowest value from a Resultset and write it to a text box
In this example the script is placed in the button
Retrieve the lowest value from a Resultset and write it to a text box Read More »
Retrieve the highest value from a Resultset and write it to a text box
In this example the script is placed in the button
Retrieve the highest value from a Resultset and write it to a text box Read More »
Show / Hide a Table using a single line of script
This script uses a toggle pattern to set the table visibility to the opposite of its current visibility.No need for IF/ELSE statements You could expand this logic to toggle visibility of multiple widgets at the same time Why do we define the variable: newState Instead of doing: Table_1.setVisible(!Table_1.isVisible());Chart_1.setVisible(!Table_1.isVisible()); We calculate once: var newState = !Table_1.isVisible();
Show / Hide a Table using a single line of script Read More »
Nested Else If Condition basic example
The example code runs through each condition sequentially, if a condition is not met it will go to the next âElse ifâ statement. This code will write âValue 2 condition metâ in the console logIt wonât run the else { if (VALUE3 <301) section of the code.
Nested Else If Condition basic example Read More »