Forum Discussion
Dynamic filtering of data
The way to do it is to :
1) add a row-index column (unique value for all rows) to original table
2) duplicate original table, and unpivot copied table. The new table should now contain 3 columns: row-index, attribute (column name) and value
3) manage relationship between filter-table and original table (cross filter direction = Both)
4) add 2 sliders to report page (columns from filter-table):
slider 1: Field = Attribute (dropdown, single-select = On) --> This is used to select column to filter on
slider 2: Field = Value --> This is used to select alowed values for selected filter
5) to add more filters: redo step 2-4
- Note that each slider-pair in the report equires a new unpivoted duplicate of the original data-table.
- The solution may therefore not be applicable for large data sets
The way to do it is to :
1) add a row-index column (unique value for all rows) to original table
2) duplicate original table, and unpivot copied table. The new table should now contain 3 columns: row-index, attribute (column name) and value
3) manage relationship between filter-table and original table (cross filter direction = Both)
4) add 2 sliders to report page (columns from filter-table):
slider 1: Field = Attribute (dropdown, single-select = On) --> This is used to select column to filter on
slider 2: Field = Value --> This is used to select alowed values for selected filter
5) to add more filters: redo step 2-4
- Note that each slider-pair in the report equires a new unpivoted duplicate of the original data-table.
- The solution may therefore not be applicable for large data sets