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

Forum Posts

Resolved! Stacked bar charts - Values and proportions

Hi there! How do I get rid of / % (ie - % of total) when we hover on the widget. While I already show the value in a absolute % representation whereas the % of total against a % value do not make sense in my use case. 

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 11 - Data Pipeline
  • 771 Views
  • 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
  • 987 Views
  • 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
  • 3269 Views
  • 4 replies
  • 0 kudos

Resolved! Blox - Container Format (Remove White Field Space Below Container)

I am using a BloX container as a title.  I have white space below the container (see picture).  "spacing": {"padding":0} in Configuration.    BloX script below.  Is there a tip to remove the white field space below the container? { "style": "", "s...

Dennis_M by 9 - Travel Pro
  • 4646 Views
  • 4 replies
  • 0 kudos

Resolved! How to Calculate YTD by Month in a pivot table

I have a pivot table that works for my team. It looks like this: The variance column is a simple formula showing the difference between Budget and Revenue (Revenue - Budget). I have received a request to expand this pivot (or create a new one based ...

oliviar_0-1654019798132.png
oliviar by 7 - Data Storage
  • 9537 Views
  • 2 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 any...

smorebs by 8 - Cloud Apps
  • 817 Views
  • 0 replies
  • 0 kudos

Resolved! How do I pass the content of a text Input to a Blox filter?

I'm trying to create a slightly more restrictive text filter using Blox. I want my users to be able to type in a search term to filter on, but I only want them to be able to do a 'contains' filter, not the other free text filter options.I've managed ...

The Houdini Report

We are finally releasing our Analytics Suite to our customers and I would like to create a Dashboard/Report to specifically show items that have "Disappeared" from weekly sales.  If an item was consistently sold for 3 weeks or more and then 3 weeks g...

NexGenDSD by 7 - Data Storage
  • 1001 Views
  • 0 replies
  • 0 kudos

Resolved! In Sisense, how can you "group by" in ranges?

Suppose I have data organized in a pivot (widget). where within the pivot table, each rows represent a team member, e.g. (jack, jon, doe etc). The team members are part of teams, where 'team name' is a column in the same pivot (widget) I'd like to ge...

leo82 by 9 - Travel Pro
  • 1995 Views
  • 1 replies
  • 0 kudos

Creating new user roles?

I am looking at customizing user roles and am wondering if it is possible to create a new role type.  https://documentation.sisense.com/docs/customizing-user-roles For example, I'd like to make a new role that is between a Viewer and a Designer that ...

vrice by 8 - Cloud Apps
  • 1348 Views
  • 1 replies
  • 1 kudos

How to filter out dates past the current date

Hi! I have one metric here that is using the PREV() function to get data from 4 weeks ago. Hence, the date rows go all the way to 4 weeks in the future here. I have included a widget filter called current_date_flag, which is basically a row in my EC ...

amelia by 10 - ETL
  • 787 Views
  • 0 replies
  • 0 kudos

Blox Template - Cards

Here is a blox template for cards Refer : https://www.binextlevel.com/post/blox-template-2-cards    Blox Editor Script: { "style": "", "script": "", "title": "", "showCarousel": false, "body": [ { "type": "Col...

harikm007_0-1655984684235.png harikm007_1-1655984840856.png
harikm007 by 13 - Data Warehouse
  • 1900 Views
  • 0 replies
  • 1 kudos

Filter relationships

Hi all, Sisense 2022.6 comes with Filter relationships. It says it requires the analytical engine to create these relationships. Does this mean this feature is only available for live models? Or is it also available for Elasticubes? Kind regards,Sche...

ScheurK by 9 - Travel Pro
  • 1094 Views
  • 0 replies
  • 0 kudos

Multi-Level Headings to Group Columns Together

Hi Sisense Community! I have a question with regards to dashboard design:  For the pivot table widget, would it be possible to add category headers for the metric columns like this? I have pivot tables with several metrics, so it would be ideal to gr...

Screen Shot 2022-06-17 at 11.11.15 AM.png
amelia by 10 - ETL
  • 1692 Views
  • 2 replies
  • 0 kudos

Community Content Spotlight

Check out our Software Developer Communities!