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 »
Script Logic
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 »
getMembers() doesn’t return all dimension members
The getMembers() api by default brings 200 members only. There is limit parameter in the api which you can set to integer value like 1000 to increase the default limit of 200 to this integer value.
getMembers() doesn’t return all dimension members 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 »
Stop a For IF loop when a specific condition is met
For performance reasons it makes sense to stop a âfor ifâ loop running if it has provided the required outcome.e.g. in this example we want to write the value of âiâ to the console when it is less than 5. Without the break statement the loop would write the values 0,1,2,3,4 to the console, but
Stop a For IF loop when a specific condition is met Read More »