Filter on dynamic table

Hi,

is there a way to only show data with a specific values in a dynamic table?

I would like to have some sort of ticket system and only show “active” tickets in the table and as soon as its been closed or reviewed by the user, to remove it from the dynamic table as row entry.

I just can select blueprints variable but I don’t see any further filter criteria.
In the screenshots, its shows all “severity” entries. I would like to only show the severity entries with the value “active”.

Any suggestion would be appreciated,
Cheers

Hi Annia,

You could achieve that by utilizing Analysis, you’d manipulate the data so that it will only send data when the severity status is “active”, to a device. Then you’ll display that device’s data in a dynamic table widget.

You could also achieve this by joining all your columns variables into a single variable using metadata. Then you’d utilize Formulas to check if the metadata key “severity” is “active”, If it isn’t, hide the row’s data.

You’d use a Formula like this:
equalText($metadata.status$, “active”) ? $metadata.status$ : " "

Note: the row will continue existing, you just won’t see the data within it)

The best option would be to use both, create an Analysis to manipulate the data you want to display, and use a single variable along with its metadata to display info in each column.