Frequently Asked Question

How to use Linking Element & Input Controls on datetime format dimension in the Table Filter

Last Updated 3 years ago

You need to display date/datetime values in the Table Filter component
The Native Webi Linking Element or the Filtering Controls (radio buttons / checkboxes) don't work with date values

Create a query with a date/datetime dimension and mesure(s) then display the result in a Webi table and a Table Filter N4V :

Create a native Webi linking element on the Table FIlter

Then click on a line in the Table Filter : the filtering doesn't work :

Create a Webi variable of type dimension and transform the date value to a corresponding text value :

The formula can be

Change the assignment of your dimension in the Table Filter (replace the date/datetime dimension by the text variable) :

Then the native Webi linking is now working :

Remove the element linking

Then create an Input Control (simple value list) based on the Webi Variable :

In the Extended Parameters of the Table Filter and feed the Controls setting as follow :

Then select a line and click on the filter button to apply the selection : Selection is working

Remove the Input Control and create a multi value Input Control based on the Webi variable :

and change the settings in the Extended Parameters of the Table Filter :

Then select many lines and click on the filter button to apply the selection : Selection is working