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.
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 ...
Disclaimer: Please note that this blog post contains one possible custom workaround solution for users with similar use cases. We cannot guarantee that the custom code solution described in this post will work in every scenario or with every Sisense ...
Question: For a specific industry, like Education, even though the number of days is roughly the same every year, each academic year can start and end on different dates. The usual way of calculating YTD wouldn't work for this requirements because s...
Question: A data source in your ElastiCube contains a field with multiple values in it delimited by a particular character (i.e - comma, semicolon, space, etc.). You need to parse that field and create a table with a record for every value in the del...
Question: When using "Accumulate By" builds (see below), Sisense will only import "new" records based on a selected INT or DATETIME index field - if values in the source DB exceed the maximum value of that index as of the previous ElastiCube build, t...
Question: Sisense Service hangs and I try to start them in Windows Services, but the usual net stop & net start will not restart them. net stop /y will stop all dependencies. Solution: Follow the instructions below to force start a Sisense Servi...
Add the following css to the style tag of the main blox property.Modify the widgetid value to match your blox widget ID. The ID is the text after /widgets/ in the URL bar.Modify the color to be whatever color you'd like to alternate between.widget[wi...
Today we will create a quiz widget in Blox that will looks something like this:This is a blox exercise to show a simple use case for custom actions.The first step is creating a data source file.You can create some csv with have some questions answers...
Question: How can I access all the cubes from another server, if I installed another Sisense system on another machineSolution: In order to get the cubes from another server you can follow these steps. If the computer you're working on is a computer ...
Question: Due to security considerations I want to be able to disable TLS1.0 with a view to disabling TLS1.1Solution: Starting in Sisense 7.4, it became pretty straightforward to disable traffic on TLS 1.0 and 1.1.Setting this up involves two steps:F...
Analytical NeedFact tables may include a wide date range. For instance, a table can have historical dates without any transaction of the current year,The Need : filter the dashboard based on the latest year in the data Modeling Challenge We need t...
Analytical Need Pareto analysis is a technique based on the Pareto Principle which states that 80 percent of problems or effects are produced by 20 percent of causes. This type of analysis can be useful in the stage of decision making, to identify t...
Analytical Need Aggregation functions are used to group a set of values to perform calculations that return a single value. SUM(), MEDIAN(), and COUNT() functions are some of the most common aggregation functions examples. Simple aggregation func...
After publishing a widget, we can access it's attributes to further modify it to our requirements.Step 1 - Find the Widget titleNamed 'widgettitle' from the browser's console, by adding a 'debugger' to the this.initializing of the dashboard. In the t...
Below gives a solution on how to compare this year results up to today with previous year until the same parallel day.Solution: If you want to compare this year and the previous year you can add a widget filter where you will choose the current day ...
How do I find insights without having to dig through lots of dashboards & data? This question is being asked by many of our customers who are looking for the easiest way to identify and stay on top of important business events. To address this need,...
The last month with data isn't the current calendar month (payroll for instance).The out of the box feature of Sisense supports only the last calendar month Below shows a solution to have a default filter that shows the most updated month with data....
Analytical Need Gauges are types of widgets that are very helpful in presenting progress or whether a KPI is met such as current state vs. expected state based on previous calculated value.At times, we might be interested to show a target that needs...
Analytical Need When designing our dashboards and widgets, we should always consider the visuals and UI to convey the message of our widgets and help our users to consume the data easily, and take actionable business decisions based on it.Many times...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-ManyData Relationships: Check Type of relationshipData Relationships: O...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
