TABLES KB PAGE

Retrieve a single measure value selected by a user in a table

This script is useful for capturing the measure value clicked by an end user in a table.I typically use this logic to capture a value and pass it as a filter elsewhere. The Script below is placed in the ‘onSelect’ event of a table Extra line of code to write the value to a text […]

Retrieve a single measure value selected by a user in a table Read More »

Use the first & last result / row value from a table as a filter

jbarlowjb

I had a requirement to filter a chart on the highest and lowest value shown in a table.The table was sorted by measure value Z-A, so the first and last row will always be the highest and lowest.

Use the first & last result / row value from a table as a filter Read More »

Filter to show the first row in a table

jbarlowjb

This script will dynamically filter a table to show whatever value is present in the first row The Script below could be placed in a button for example

Filter to show the first row in a table Read More »