Filter Header
Download: Filter Header
Introduction
This article explains how to add a report header as a plugin in Sisense.
Purpose/Benefits
Even though dashboard filters are displayed on the right hand side of each dashboard, some user prefer to see the selected filter values at the top of the dashboard. The included plugin adds a new widget that displays the title of the report, the filters added to the dashboard, and an optional icon. The title is pulled from the dashboard name. The filters and their values come from all the dashboard filters set on the right panel. The icon can be set in the widget's settings panel.
Steps
The following steps will walk through the process of adding the new chart type and creating a sample funnel chart.
Step 1 - Add the Plugin
Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server. Now, when you create a new widget the filter header should show up in the list of options
Step 2 - Create the Chart
On your dashboard, click the Create Widget button and select Advanced Configuration. Next, select the Filter Header from the chart types menu. It will automatically pull in the title and the dashboard filters, and if you want to add a logo/icon then just enter the URL in the setting panel.
Notes
- This attached plugin code was updated on 7/21/2015, in order to become compatible with the current release of Sisense (version 5.8.0)
- This attached plugin code was updated on 8/10/2015, in order to fix issues with dependent filters and filtering on quarters
- This attached plugin was updated on 8/9/2016, in order to work with Sisense v6.4
-
Great Widget. Couple Questions. Is there a way to increase the number of columns the filters are shown on. (i.e increase it to three or four columns rather than two). Also, i can not seem to get the image URL to work. When I insert one and click Apply the image icon changes to a broken image icon. Is there a way to fix this?
Thanks
-
Hi Cassandra & Ryan,
There was an update to Sisense that overlaid a "No Results" icon when it thought a widget had no data. The plugin has been updated to hide this overlay, so if you download the new version you should see your image icon and any filters that are set.
Thanks,
-Takashi
-
On smaller screen sizes (1280x1024) the columns wrap to one and the bottom filter info is lost. The widget does not scroll so there Is no way to see the data. See attached screen shots.
Sisense-FilterLabelWidgetIssue.png -
Jim,
Can you tell me how did you edited the .css to remove the widget title? (What code did you use?)
Best Regards
Hello Takashi,
I have the same problem as Jim "On smaller screen sizes (1280x1024) the columns wrap to one and the bottom filter info is lost.", can you help us fix this?
Best Regards
-
In the plug-in folder on your server is a widget.css file for the plug-in. I set the Dashboard label tag font color to white (we have a white background) and the font size to 2px to shrink the space. See .css below:
.filterDashboardLabel {
font-size: 2px;
font-weight: normal;
line-height: 10px;
color: #ffffff;
font-family: "Times New Roman", Times, serif;
margin-left: 2px;
} -
Hi Michal,
Can you download the latest and let me know if this works again? I just updated the plugin, and it is working on version 6.4 now.
Hi Sergio and Jim,
This behavior is defined within the CSS of the plugin, so that it wraps around when you have lots of width. You are correct that if you have a narrow space, it won't be able to wrap, so the labels will stack upon each other. Your options are to either make the plugin taller, or adjust the CSS to reduce the height of the filterTitle and filterValue classes (found in widget.css)
Hope this helps!
-
Hi fellow friends,
When I export this within a dashboard as a PDF with the "as-is" setting, the filters arranged in a 3x2 come out as a single column. I've tried to work around this by exporting the dashboard and changing the size of the widget and then importing it back in but it doesn't fix the issue, the filters just get cut off by the next widget instead.
-
Great plugin! I was able to edit the widget.css and widget.js to do what I needed it to do. For our compliance department, we have to add disclosures based on the filters selected. Is there a way to make it auto size? I've tried to make the widget as large as possible on the dashboard since it's at the bottom. However, that doesn't control it for all cases.
-
Hi Malinda, it possible to create an auto size. However this is not implemented in this plugin yet. Please feel free to try and modify the plugin and improve it.
I saw that in Table with aggregation widget - in design there is an option for automatic an manual column width, you might be able to use some reference from Table Widget with Aggregation plugin.
-
Hi Janos,
You might consider using the custom filter widget plugin. LINK
-
When jumping in to a dashboard using the filter header, the date filter that I have is always off by +1 day.
Example: Date Filter = 8/8/2017, Filter header displays 8/9/2017
The filter value passed is correct. The drill down is opening with the correct date value and the data is for the filter date.
A browser refresh does not fix the display issue.
The Filter header widget displays the correct value:
- When I generate the pdf.
- After re-selecting the date value.
- When I open the drill down dash board directly (not jump into)I am using 6.6.1.13002
Any thoughts?
Please sign in to leave a comment.
Comments
28 comments