IntroductionIn many use cases, the most current state of your KPI is as important as the trend of that KPI over time (for example, the trend of stock price, impressions or reach of your social media campaigns, etc), so you want to show both an indica...
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:I would like to be able to track memory consumption of my Elasticubes, but I can't find an easy way to link the process ID of my Elasticube to the cube name.Solution:If you open the Task Manager, go to the Details tab and right-click on one ...
Question: I want to use the Date picker for filtering, however, the dates selected are not getting preserved by the date picker and might be confusing for the end users whether the date is selected or not.Solution: You can use the script to keep the ...
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, mathem...
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:To accomplis...
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 = widge...
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: When applying the script in Blox - the change is not applied in PDF.The example of the script:This looks fine in the Blox editor, Dashboard and PDF preview:But the script is not applied to the exported PDF:Solution: Replacing the arrow func...
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 there...
Question: A relatively common database design strategy is to have a tag column with an arbitrary number of tagsHere is an example in which we look at numbers between 1 and 10 and tag them as even, odd, perfect, or parts of the Fibonacci sequence:Now ...
Question: Is there a way to tie a default filter (set to "all") so that instead of Blox just displaying the top name in from the data, it triggers a custom phrase instead (like "Aggregate")?Solution: Here's a simple way to do something of the kind! T...
I had a requirement to generate a fixed layout of tables, where the values in each cell were calculations (much like an excel worksheet) as opposed to aggregations grouped by a dimension (typically how we use pivot tables).Using Blox we created some ...
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email community@sisense.com
