Custom UI Colours (Instead Of Yellow)
Download: For V7.0 - V7.1, For V7.2 and V7.3, For V7.4 Plugin allows changing Sisense yellow color to any color you wish. This plugin causes instability with some Sisense versions and is not supported. Use at your own risk. STEPS STEP 1 - ADD THE PLUGIN Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\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. STEP 2 - USE THE PLUGIN Reload sisense web app. BEFORE: AFTER: CONFIGURATION: Navigate to .../styles in the plugin folder and edit config.less (or config.scss) file with colors according to your desire. Change log: 05/17/2019 - Support for V7.4 and change color for button on login page. NOTE: In the latest versions of Sisense (Windows and Linux - 8.2+), you have this feature baked into the product - Look & Feel (on the Admin tab)Track Dashboard Usage With Google Analytics
Plugin Overview This plugin registers every page view from your Sisense instance to your Google Analytics account. https://analytics.google.com Configuration You must specify your Google Analytics "tracking ID" by editing the main.js file. By default, page tracking includes cross session / device tracking using the page viewers' Sisense internal user id. This can be disabled by editing the main.js file. Design Options This plugin is a wrapper for analytics.js. Review the Google Analytics developer guide for full details. https://developers.google.com/analytics/devguides/collection/analyticsjs If you have multiple environments such as development I have found two approaches to segregate tracking information. Utilize a different Google Analytics "tracking ID" for each environment Update the Sisense branding "pageTitle" value to include a suffix that indicates the environment. For example "My Analytics Application - DEV". This would allow you to segment the page view within Google Analytics. This requires the option/license to brand your Sisense installation. Installation Instructions Download the plugin here Extract googleAnalytics_v20170810.zip to your Sisense installations plugin directory. This usually located "C:\Program Files\Sisense\PrismWeb\plugins" Modify the main.js file as directed in the Configuration Section above. By default, this file is located at "C:\Program Files\Sisense\PrismWeb\plugins\googleAnalytics\main.js". Restart IIS to register the new plugin. Support This plugin has been tested with Sisense version 6.6.1.13002. This plugin comes with no warranty and you use it at your own risk. If you have issues, share your experiences on this forum for community support. Revisions 20170822 - Replace ajax call to get internal user id with prism variable reference 20170810 - Initial ReleaseThe Smart Label
Download: Smart Label Introduction The following article describes steps needed to add to create smart text widget to present ElastiCube fields as text. Implementaion Steps Extract the folder in the attached zip file into \...\Sisense\PrismWeb\plugins. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. Create new widget and chose the smart label icon from the list Choose a field to present, set a design and hit "Apply" [Please note, that in case you have multiple values, it will present the first one. Therefore, it is always better to change the type of the filter to single value only, like in the given example] This plug in works on Version: L8.0.5.156. Only drop the plug in folder contained in the download folder into the plug ins folder in Sisense.The Chart Label Order Changer
Download: Change Labels Introduction The Label Changer is efficient when wanting to order text values in a specific order which is not alphabetical order. For example: Ordering Week days names as : Sunday, Monday… or Month names as: January, February etc… The plugins works with multiple values on Bar Chart, Column Chart and Line Chart. The plugin also supports break by. Steps In order to add the Label Changer plugin, please follow the listed steps below: STEP 1: Create a custom field in the EC that has the desired values with numbers at the start. Each value will begin with the ordered number (The first one with ‘01’ ) and the desired text to present in the dashboard. Examples: For the days of the week use this text: CASE WHEN DayOfWeek(Date) = 1 THEN '01Sunday' WHEN DayOfWeek(Date) = 2 THEN '02Monday' WHEN DayOfWeek(Date) = 3 THEN '03Tuesday' WHEN DayOfWeek(Date) = 4 THEN '04Wednesday' WHEN DayOfWeek(Date) = 5 THEN '05Thursday' WHEN DayOfWeek(Date) = 6 THEN '06Friday' WHEN DayOfWeek(Date) = 7 THEN '07Saturday' ELSE '' END For the Month Names use this text: CASE WHEN getMonth(Date) = 1 THEN '01January' WHEN getMonth(Date) = 2 THEN '02February' WHEN getMonth(Date) = 3 THEN '03March' WHEN getMonth(Date) = 4 THEN '04April' WHEN getMonth(Date) = 5 THEN '05May' WHEN getMonth(Date) = 6 THEN '06June' WHEN getMonth(Date) = 7 THEN '07July' WHEN getMonth(Date) = 8 THEN '08August' WHEN getMonth(Date) = 9 THEN '09September' WHEN getMonth(Date) = 10 THEN '10October' WHEN getMonth(Date) = 11 THEN '11November' WHEN getMonth(Date) = 12 THEN '12December' ELSE '' END Status sorting: CASE WHEN Status LIKE 'Fail' THEN '01Fail' WHEN Status LIKE 'Medium' THEN '02Medium' WHEN Status LIKE 'AboveAverage' THEN '03AboveAverage' WHEN Status LIKE 'High' THEN '04High' WHEN Status LIKE 'Amazing' THEN '05Amazing' ELSE '' END STEP 2: DOWNLOAD AND EXTRACT THE ENCLOSED CHANGELABELS.RAR ZIP FILE INTO THE PLUGINS FOLDER: C:\Program Files\Sisense\PrismWeb\plugins\, if the "plugins" folder is not there, please create it. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. Step 3: Edit config file under: (Right Click and Edit with Notepad ++) C:\Program Files\Sisense\PrismWeb\plugins\ChangeLabels\config.js Add the Custom fields (You can create more than one) you created to the dimensionsToChange with as: ["[TableName.FieldName]"] For Example: var dimensionsToChange = ["[Commerce.DayofWeek]","[Commerce.MonthName]"]; Step 4: Create a chart with the custom field you created. Press Apply. Refresh the dashboard and the values will appear without the numbers. Example of the Plugin with DayofWeek field break by Age Range: General Note: This plug-in actually removes the first 2 characters from the values of the field in the web display but maintains the order of the values according to the 01 / 02 / 03 etc. In case you have values that begin with numbers please add 1. / 2. / 3. etc. to the beginning of the values (instead of 01 / 02 / 03).D3 Tree Ring Chart
Download: Tree Ring Introduction This article explains how to import a Tree Ring Chart from D3 as a plugin in Sisense. Purpose/Benefits Tree charts show the relationship between different levels of data. It can be used visualizes how certain metrics roll up from the bottom level to the top. See the referenced wiki page on tree charts for more information. Steps The following steps will walk through the process of adding the new chart type and creating a sample Tree Ring 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 tree ring chart 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 Tree Ring Chart from the chart types menu. Choose between 1 and 3 dimensions to use as the hierarchy, making sure the top level items are listed first. Then, pick a metric to use as the size. The size of each circle should correlate to its value. Notes This plugin uses the default sisense color palette, but this can be customized. If you open widget.js in any text editor, there is a variable name Colors on line 127. Enter in your own hex color codes, and they will be reflected in the chart. In order to calculate the values for each node, this plugin takes the SUM of the child nodes. This means that the results may look a bit off when using other formulas like COUNT, AVERAGE, MEDIAN, etc. References D3 Tree Ring Chart - GitHub project that this chart is based off Tree Structure WikipediaCustomize Value Labels
Download: Custom Value Labels Introduction This article explains how to customize how value labels are displayed on common chart types. Purpose/Benefits When you have limited screen real estate, you may see your value labels overlap each other. Adding the plugin gives you additional options for choosing only specific value labels to display Steps The following steps will walk through the process of adding the plugin. 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/edit a widget there should be additional settings for each value measure. STEP 2 - CREATE THE CHART On your dashboard, click the Create Widget button and select Advanced Configuration. Add in a dimension and some values as the data series, then click on the settings icon for a value measure. You should see an additional option for Value Labels, which has a submenu for determining which values to display. References/Notes Supported Chart Types: Column, Bar, Area, Line If no options are selected and the native Value Labels toggle is enabled, all data points will show their data labels. If you select one of these custom options, it will override the native Value Labels toggle.Custom-Style Plugin
Download: Custom Style Introduction As a web-based extensible platform, Sisense's web look and feel can be customized using CSS. This plugin provides a framework for letting customers apply custom styles to the Sisense web application. For more information about CSS, please see Mozilla's developer guide: https://developer.mozilla.org/en-US/docs/Web/CSS/Reference. For more information about Sisense's JavaScript API, please see https://sisense.dev/guides/customJs/jsApiRef/. What's Included This plugin contains Roboto, a custom font from Google Fonts (https://fonts.google.com/) and the CSS needed to use it in the web application. You can use it as a framework to apply other fonts. It also includes an example of modifying the last build time's font color to green. For information about customizing the indicator, please see https://sisense.dev/guides/customJs/jsApiRef/widgetClass/indicator.html. How To Customize CSS relies on pairs of selectors (web elements to modify) and properties (how to modify the elements). To learn about general selector syntax, see https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Selectors. To learn about general available properties, see https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Properties_Reference. To see the actual elements Sisense uses in order to use them in your selectors, use your web browser's Developer Tools console to inspect the elements. Advanced Editing There are some restrictions on what elements this plugin (and the Sisense plugin framework) can modify. To make customized modifications to other elements, Sisense's source CSS files are located at C:\Program Files\Sisense\PrismWeb\client\styles. Please note that you make all changes to Sisense source styles at your own risk. In addition, any modifications you make to these files will be overwritten with each upgrade, reinstallation, or repair. Steps To Implement Step 1: Download the plugin Download and extract it to the following location: C:\Program Files\Sisense\PrismWeb\plugins. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If your version of Sisense is 6.6.1 or lower, restart IIS (run 'iisreset' in the Windows Command Prompt as an administrator) Step 2: Edit the stylesheet Open "custom.css" file which is located in C:\Program Files\Sisense\PrismWeb\plugins\customStyle\styles. Edit the CSS file as desired and save the file afterwards. Refresh the dashboard page - it may take a minute for the plugin update to come through. Disclaimer This plugin has been written and tested in Sisense 7.1. Please note that the elements vary from Sisense version to version. Always ensure you have the license rights to use custom fonts. This plugin is not supported or reviewed with each updated version of Sisense; you use it at your own risk. For troubleshooting questions, please use the comments below or refer to general web CSS documentation. Update on March 23, 2018 - Updated elements for Sisense 7.x. Added font example and more information about CSS.