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

Forum Posts

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 8 - Cloud Apps
  • 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

Resolved! Overlapping Column Chart

I am looking at a Goal vs. Actual column chart. I have two context cases for this framework: units goal and units sold, and revenue goal and revenue collected.I have my bar chart working correctly, but I want to change the design of it a bit to be mo...

oliviar_0-1657051095250.png oliviar_1-1657051261075.png
oliviar by 7 - Data Storage
  • 5 replies
  • 0 kudos

Accordion from Textbox

We've been using the windows version for a few years and had Implemented Accordions on top of text boxes in order to give our users a better flow/experience. We're starting the move over to Linux, but this function seems to be incompatible. Has anyon...

smorebs by 7 - Data Storage
  • 0 replies
  • 0 kudos

Building Cube - Long Time Initializing and Finalizing

My cubes can take 15-20 minutes during the initializing and finalizing steps when building. This is out of the 25-30 minutes it takes to do the entire build - so over 50% of our build time is coming from these steps. Does anyone have an idea what cou...

vrice by 8 - Cloud Apps
  • 2 replies
  • 0 kudos
Community Toolbox

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

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy