This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
IntroductionSometimes when your analyzing sales you may want to look at products that are not being sold. Or maybe for a service provider you may want to see territories where you have no subscriptions. Unfortunately, data typically does not contain ...
IntroductionThis Post Explains how to create a new column that will calculate the week number of a Quarter.Business CaseIn many cases Business Analyst would like to track trends over time aggregated by quarters but broken down to the week within each...
Introduction:The Dynamic iFrame template contains an iFrame element whose hosted page's URL is set by data, fetched from the Elasticube, or contains it.Since the URL is data-related, the content of the iFrame would be sensitive to filters.Please note...
Introduction: The Jumbotron template mimics Bootstrap's Jumbotron element and suggests an elegant and actionable header. Installation Instructions: 1. Download the attached template 2. Extract the json file into your BloX template directory: C:\...
Introduction:The Dynamic Table template allows you to create a pivot table which dynamically sizes columns based on the size of the browser.This template is structured for 4 columns, each of which are set to 25% of the column set size, which changes ...
ChallengeWhen developing a web page or a BloX widget designers face the same challenge. Accurately placing text and other design elements in the design space are difficult and arduous processes. Furthermore, advanced knowledge of CSS is required to a...
Question: I want to edit existing Custom Import Query, how can I do so? Solution: From the context menu open on the table with custom import query Change connection settings for table: From there you will be able to see your custom import query...
ObjectiveSend the user information along with data in a BloX Post payload without additional data security or dimension transformation.MethodThis method uses the following BloX components:A widget scriptA text input fieldA standard post actionHIGH-LE...
The Gradient color in bar/column/line/area chart script contains a styled title bar of 3 KPI with a gradient background. Installation Instructions: 1. Download the attached template 2. Extract the json file into your BloX template directory: C:\Pro...
Question: When an elasticube is created in desktop version of elasticube manager, only a .ecube file gets created, where as when an elasticube is created in web version of elasticube manager, a folder with the elasticube name is created that contain...
This is a purely HTML, SVG, and CSS widget requiring no Javascript.The style of the guage is:.circular-chart { display: block; margin: 10px auto; max-width: 80%; max-height: 250px; } .circle-bg { fill: none; stroke: #eee; stroke-width: 3.8; } .circ...
Question:This post we will talk about accumulation via millisec by using a unix timestamp transformationIn this use case, We will be working with a CData Elasticsearch ODBC driver and client need a way to accumulate data base off milliseconds.Naively...
Question: How to add a main header row that contains the column title of each row of data?Solution: You can solve it with a widget script, please follow these steps:1. Add a class to your "title", or the part that you only want to repeat once (in our...
Question:SQL NULL is not technically a value, but rather a state. Fields are not equal or not equal to null, they are or are not null. As such, null fields can get a little tricky when attempting different kinds of transformations.For example, mathe...
The information in a blox text box can be used to create a filter.I ran into a use case wherein the client wanted to create a filter based on a list of values in csv file. The filter dimension has thousands of options and users would often need to se...
Question: In instances where tables within SQL Server contain JSON objects within a column you can use the import sql query editor feature in Sisense to flatten these objects into individual fields. For example: Can be turned into: Solution: T...
1. Apply this widget script (found in the widget menu) to the BloX widget:var ChooseYourHighlightColor = '#00cee6'; widget.on('ready',function(widget, args){ var filterToFind = widget.metadata.panels[0].items[0].jaql.dim; var dashboardFilters = ...
Question: Some organizations provide Sisense to their clients as part of their business offering. Some of these organizations would like also to provide clients with the consortium data derived from Sisense - a single ElastiCube where clients submit ...
Use this Date Offset Filter Buttons template to add buttons to your dashboards that allow your users to filter the dashboard by a month offset.After importing the template, you can modify the JAQL in the Editor section to provide the table and column...
Question: What is the best way to remove leading zeros? I have a field that is alphanumeric values (JONESBJ001, SMITH KC02, 0000012345, 0000555213. Solution: If all of your data with leading zeros will always be some sort of numerical string (ie ...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
