The Sticky Filters add-on allows users to configure dashboard filters that remain active as they navigate from one dashboard to another. Whenever the Sticky Filters option is enabled, the selected filter will be saved as a sticky filter for any dashboard the user may navigate to that contains that filter. If a filter marked as sticky does not exist in a dashboard, it will remain active in the filters collection so that it can be used when the user arrives to a dashboard that has that filter. Filters will be marked as ‘sticky’ at the dashboard level. When arriving at a dashboard where sticky filters have not been activated, filter behavior will revert to the Sisense default.
Note: Every change in the sticky filter setting will require republishing of the dashboard.
Installation
- Download the attachment.
- Extract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file.
For V7.1 and earlier: C:Program FilesSisensePrismWebplugins
For V7.2 and later: C:Program FilesSisenseappplugins
- Configure the config.js file described below.
- Refresh your dashboard.
Implementation
- Create dashboard A and dashboard B with the same datasource.
- Add the same filter A to both dashboards.
- Configure the config.js file in the plugins folder to contain filter A.
- Update filter A selection on dashboard A.
- Open dashboard B.
The filter A selection on dashboard B should be the same as dashboard A.
Configuration
In the config.js file located inside the plugin folder, you define which filters are sticky filters in the stickyFiltersList array.
The “stickyFiltersList” array should be updated to contain all of the dimension phrase strings pertaining to each filter, for example:
mod.stickyFiltersList = [
“[country.Country]”,
“[Commerce.Gender]”,
“[Commerce.Age Range]”,
“[Brand.Brand]”,
“[Commerce.Date (Calendar)]”,
];
Limitations
- The plugin does not support SisenseJS.
- The plugin does not take into account different ElastiCubes. All dimensions with the same name from all ElastiCubes will be set as sticky if they are configured in the config.js file.
- Cascading filters: Sticky filters are applied on cascading filters only if the selections are not filtered out by the parent items. If a selection cannot be applied to an item, its value is set to:
- In the case of single selections, the value is changed to the first option available.
- In the case of multi-selections, the value is set to ‘Include All’
- If there are no members matching to the parents’ selections, the filter selection is not being changed.
This is a premium Sisense add-on. For pricing details please get in touch with
your CSM
Added support for version L2022.3 – Mar. 11, 2022
Added support for version L2022.2 – Feb. 22, 2022
- Fixed error in the console after the drill
Added support for version L2022.2 – Feb. 10, 2022
- Installation steps have been changed to support installation with scripts
Added support for version L2022.1 – Jan. 21, 2022
Added support for version L2021.12.0 – Dec. 09, 2021
Added support for versions L2021.11.0, W2021.9.0 – Nov. 01, 2021
Added support for version L2021.10.0 – Sept. 27, 2021
- Added support for v1.0.12
Added support for version L2021.9.0 – Sept. 03, 2021
Added support for version L2021.8.0 – Aug. 17, 2021
Added support for versions L2021.3.2, L2021.5.0 – July 07, 2021
Added support for versions L2021.3.1, 20.21.2 – April 29, 2021
Added support for version L2021.1.1 – Feb. 22, 2021
Added support for version L8.2.4, 8.2.5 – Dec. 28, 2020
Added support for version L8.2.1 – Aug. 28, 2020
Added support for version L8.0.5 – July 27, 2020
Added support for version 8.2.2 – June 16, 2020
Added support for version 8.2.1 – May 19, 2020
Added support for version 8.2 – April 22, 2020
Jan. 23, 2020
- Fixed random issue causing by wrong filter update
Versions L8.0.0, 8.0.1 – Sept. 09, 2019
Version 8.0.0 – Sept. 09, 2019
Fixed issue on when we getting custom filter instead of original after sharing the dashboard
Jan. 14, 2020
- Fixed issue: Sticky filters now works when there are two date filters on a dashboard
