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

Forum Posts

Iteration in Blox with Header iterations

I want to make the iteration over the Form Name marked(in red) in the below image. So, basically here there is a header name which has some attributes and their corresponding values which is different for every header and also there are multiple such...

Hitendra_Dixit_0-1655319196883.png

Resolved! Hide Widget

Hi, I referenced this post to arrange widgets https://community.sisense.com/t5/build-analytics/arranging-widgets-in-a-dashboard/m-p/2827 I want the widgets I am referencing to remain on the same dashboard, but I want to hide them so that they are onl...

gwolfe by 9 - Travel Pro
  • 985 Views
  • 2 replies
  • 0 kudos

Resolved! Pivot 2.0 - Manipulating a Pivot Chart

Introduction The following article discusses how to manipulate the data and styling of your Pivot 2.0 widget.Please refer to the following article first: https://sisense.dev/reference/js/widget/pivot2.html. Cell Identification To manipulate a pivot c...

Ophir_Buchman_0-1655292033643.png Ophir_Buchman_1-1655292049836.png Ophir_Buchman_3-1655292257999.png Ophir_Buchman_4-1655292270997.png

Resolved! Filtering until last week

Hi! I am creating a pivot table and I currently have all the values populated until the end of this year. However, I would only like to include values up until the previous week, which is a dynamic date. Is there an advanced filter I could use that w...

amelia by 10 - ETL
  • 1067 Views
  • 4 replies
  • 0 kudos

Adding text to indicator widget

Hi! I have an indicator widget that is updated weekly to show the latest weekly values. As such, I would like to have a line underneath this number that says something like 'updated as of *latest week date*' . The date would have to be updated based ...

amelia by 10 - ETL
  • 936 Views
  • 2 replies
  • 0 kudos

Dashboard - Passing Filter Values Using URL Parameters

A customer may want to pass a filter value using the URL (as a parameter). A common case could be when an external system launches a dashboard and wants it to default to a specific value.The following script allows you to parse the parameters receive...

Ophir_Buchman_0-1654805158204.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Bar Chart - Format a bar to have rounded corners

When creating a bar chart, you might want to design it to have rounded corners To round all corners - Apply the following widget script: widget.on('processresult',function(widget,result) { result.result.plotOptions.bar.borderRadius = 10;}); Before Af...

Ophir_Buchman_0-1654799819364.png Ophir_Buchman_1-1654799836752.png Ophir_Buchman_2-1654800115515.png Ophir_Buchman_3-1654800128976.png

Column Chart - Format a column to have rounded corners

When creating a column chart, you might want to design it to have rounded corners To round all corners - Apply the following widget script: widget.on('processresult',function(widget,result) { result.result.plotOptions.column.borderRadius = 10;}); Bef...

Ophir_Buchman_0-1654798931497.png Ophir_Buchman_1-1654798941442.png Ophir_Buchman_2-1654799261604.png Ophir_Buchman_3-1654799271095.png

Case Statement at Widget Editor Level

Hi, I am trying to create a new dimension base off of a case statement in the widget editor, but I can't get it to work (unless it's based on a value). For example, this first snippit (this is what I need) won't work . The second will. I don't want t...

gwolfe_0-1654791729748.png gwolfe_1-1654791940004.png
gwolfe by 9 - Travel Pro
  • 621 Views
  • 2 replies
  • 0 kudos

Resolved! How do you turn a field into a formula?

I want to display a COUNT of 'Time Clock In' by Employee, and then I am going to do further math but the thing is, how do you turn it into a formula?

Jon_0-1654697399612.png
Jon by 8 - Cloud Apps
  • 593 Views
  • 2 replies
  • 0 kudos

Change Legend Category Names

Does anyone know of a script that can be used to change the names of category values for a pie chart? I have the chart below which uses a binary value and I would like to replace these values with text.

jmn3_0-1654617761654.png
jmn3 by 9 - Travel Pro
  • 975 Views
  • 4 replies
  • 0 kudos

Resolved! Secondary Indicator Widget

Good morning - I would like to create a 'simple' numerical indicator widget with a sales value as the primary metric and the target sales value as the secondary metric. The target sales value is stored in an excel sheet with a structure like this: I ...

Screen Shot 2022-06-07 at 7.13.08 AM.png Screen Shot 2022-06-07 at 7.26.15 AM.png
amelia by 10 - ETL
  • 774 Views
  • 2 replies
  • 0 kudos

Build function on custom table not working.

I have attempted, in the data source section of an elasticube/dashboard to build with changes only on a custom table (green). After 8 hours, the custom table continues to show "unbuilt changes" and at various intervals a separate table (brown) shows ...

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