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

Forum Posts

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
  • 505 Views
  • 4 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 10 - ETL
  • 223 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 8 - Cloud Apps
  • 307 Views
  • 1 replies
  • 1 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 7 - Data Storage
  • 403 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 10 - ETL
  • 525 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 13 - Data Warehouse
  • 395 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
  • 243 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 10 - ETL
  • 301 Views
  • 1 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 gro...

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

Resolved! Custom Filtering for Viewers - Blank Filter Menu

I have a dashboard with three filter buttons made from BloX that will filter the dashboard for specific time ranges (last 2 weeks, last 4 weeks, last 8 weeks). These buttons work as expected by creating a custom filter when there is no option that ma...

blankDateFilter.png
vrice by 8 - Cloud Apps
  • 432 Views
  • 1 replies
  • 0 kudos

Pivot 2.0 - Hiding Columns from the Display

When creating a Pivot 2.0 chart (Linux) you may want to hide a specific column. There are various reasons for doing so: I want to sort by a column that shouldn't be displayed I want to display a column when exporting the table to Excel or CSV, but hi...

Ophir_Buchman_0-1655368363998.png Ophir_Buchman_1-1655368535823.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Resolved! Customizable card view for widget

Hi, Can I manipulate card view for individual widgets and also easily make changes to set the card view type border only for certain sides of the (Top, Bottom, Left, Right) widget? Thanks

Community Toolbox

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

Need additional support?:

Community Support Request