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.
Forum Posts
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...
Blox KPI Sparkline Indicator: Vertical Align and Responsive Design
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:
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...
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 ...
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...
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: https://www.binextlevel.com/post/change-line-chart-to-step...
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...
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?
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,...
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...
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...
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...
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...
