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

Forum Posts

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 9 - Travel Pro
  • 1 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 9 - Travel Pro
  • 18 Views
  • 4 replies
  • 0 kudos

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
  • 32 Views
  • 3 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
  • 13 Views
  • 0 replies
  • 0 kudos

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

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

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.

Show a total value with sparkline

Hi, how can I show a total value (sum YTD), and then include a sparkline of the YTD amount by month? Here is my BloX code. This displays the monthly amount, not the YTD total. The $4,727,773 is just the current month. { "style": "", "script": "", "ti...

gwolfe_1-1656440277053.png gwolfe_0-1656440218769.png
gwolfe by 9 - Travel Pro
  • 83 Views
  • 1 replies
  • 0 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 9 - Travel Pro
  • 54 Views
  • 0 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 w...

vrice by 7 - Data Storage
  • 83 Views
  • 1 replies
  • 1 kudos

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 7 - Data Storage
  • 98 Views
  • 1 replies
  • 0 kudos

Resolved! Show Last Updated Date on Dashboard

Hi! I'm creating a dashboard and want to show when the data source for the dashboard was last refreshed at the top of the dashboard, since the users will want this. Is there any widget I can add or script to add to achieve this?

amelia by 9 - Travel Pro
  • 102 Views
  • 4 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": "ColumnSet", "columns": [ { "type": "Column", "s...

harikm007_0-1655984684235.png harikm007_1-1655984840856.png
harikm007 by 12 - Data Integration
  • 80 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
  • 66 Views
  • 0 replies
  • 0 kudos

Removing First Row

Hi Sisense Community! I would like to write a script to remove the first row of the pivot table in my widget. I don't want to use an advanced filter, as I already tried that and using a filter affects the rest of the values since I use a DIFFPASTWEEK...

amelia by 9 - Travel Pro
  • 102 Views
  • 1 replies
  • 0 kudos