In my Blox Code, if the "Panel" value is not returned, the display shows No Results. Is there anyway to display a 0 instead? Blox Code is as below: { "style": { "verticalAlignment": "center" }, "script": "", "title": "", "showCarousel": true, "carous...
I have been working on a dashboard and lots of custom Blox code since a couple of days. This has been working fine before. I did add a column to a view that is pulled via Live Model and published the Data Model. However, since, I am unable to get int...
I have this parameter from QbeeQ plugin called [@Days_Ago]. It should be used as a filter in formulas For example: Calculate total sales with [Days Ago] < = [@Days_Ago]The formula would look like ([Total Sales] , [Days Ago]) while [Days Ago] column s...
Hi there! Is there a way to order the legend in a custom sequence ( not used the break by as there are number of variables that needs to be added) without changing the chart or altering the visualisation.
Hi there! I have a field called "ABC" which is a boolean with "Yes" and "No" records. I am breaking by "ABC" in a column chart where the legends appear as "YES" and "NO" wherein I wanted to rename/append it as " ABC Yes" and "ABC No" on the widget le...
I have created a Blox Indicator with Sparkline. Wanting to center this vertically and make it responsive like the other indicators. This is a wip and hence the colors mismatch. Disregrd that aspect please. Code attached:
There is a metric that I am using for a view in a widget, as shown below: `(COUNT([user_id], [status])/COUNT([user_id])` I have a view where I have a user_id and status column. I want to create a metric with only a count of user_id where status = 'AC...
My current view has a date column and a column with metric 1 (as shown in screenshot). In the Sisense widget front-end, I aggregate the dates as weeks. This sums up metric 1 for all the dates in a week. I then use the DIFFPASTWEEK function to create ...
Hi, Is there a way to hide the 'i' icon showing the widget details at the top right corner of every widget? Thanks in Advance!
Hello, I am using the smart label widget to show the selected current year of the data. It works fine when there are several years available. But when I use the background filter to allow only one year, then the widget is showing "All" instead of the...
A step chart is a line chart in which points are connected by horizontal and vertical line segments, looking like steps of a staircase. Use below script to display line chart as steps. Refer: https://www.binextlevel.com/post/change-line-chart-to-step...
What is a sipnb file format for Jupyter notebooks import/export? I tried to google it and found absolutely nothing)The user case is the following: sometimes we need to further develop notebook's code that is already used on prod. So I would like to e...
On a chart I'd like the axis interval to be automatic, but I'd like it to choose only a whole number. Can that be done?
Hi Sisense community, I have a question: I am using RSUM to calculate the running total for Metrics 1 and 2 respectively. However, the latest running sum value is different from the grand total value in the last row. The grand total value is correct,...
Hi! When I try to do the RSUM calculation for this metric, there is an error. I am trying to do a running sum of the number of ids, but I need to filter it based on a condition. The calculation is this: RSUM(COUNT([id]), [filter]) and the error is in...
