Build Analytics
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Blox - Display 0 instead of No Results

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...

mirzay by 8 - Cloud Apps
  • 1 replies
  • 0 kudos

Existing Dashboard Page Not Loading - Error 500

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...

mirzay by 8 - Cloud Apps
  • 1 replies
  • 0 kudos

Resolved! Dynamic filter with input parameter

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...

TwieN by 8 - Cloud Apps
  • 1 replies
  • 0 kudos

Changing Legend sequence on a stacked bar

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.

Renaming the names of legend in a stacked bar chart

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...

Creating Custom Column in View with filtered column

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...

amelia by 10 - ETL
  • 2 replies
  • 0 kudos

Replicating DIFFPASTWEEK logic in BigQuery

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 ...

amelia by 10 - ETL
  • 0 replies
  • 0 kudos

Resolved! Hide Widget Detail icon

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!

Customizing smart label plugin

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...

Wantti_0-1657264555771.png Wantti_1-1657264584926.png
Wantti by 8 - Cloud Apps
  • 1 replies
  • 0 kudos

Change line chart to Step chart

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:

harikm007 by 13 - Data Warehouse
  • 0 replies
  • 0 kudos

What is sipynb file format?

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...

Laris_Fdz by 8 - Cloud Apps
  • 1 replies
  • 0 kudos

Axis interval whole number

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?

Tim by 9 - Travel Pro
  • 0 replies
  • 0 kudos

RSUM and Grand Totals are not matching

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,...

amelia by 10 - ETL
  • 0 replies
  • 0 kudos

Resolved! RSUM returning errors for query

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...

amelia by 10 - ETL
  • 4 replies
  • 0 kudos
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?