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

Forum Posts

Resolved! PastDay formula

Hi, Sisense Community,I use DiffPastPeriod() and PastDay() to show previous day's values or to calculate the difference with the previous day. BU the problem is that I don't have data for Sundays and it seems like the formulas DiffPastPeriod() and Pa...

Laris_Fdz by 8 - Cloud Apps
  • 2881 Views
  • 4 replies
  • 0 kudos

Line/Area Chart - Creating an Area Range

When creating a line chart you'd sometimes want to add a range area to emphasize an "Acceptable Range". The following script will allow you to create a widget that looks as follows: Notice the following modifications were made to the original widget...

Ophir_Buchman_0-1648707341231.png Ophir_Buchman_1-1648707745451.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Resolved! Order Months in Column chart by logical order

Hi Sisense community, I would like to order the months in my column chart according to the logical order, but right now it's mainly showing alphabetical order. Would anyone be able to assist on this? Ideally I would like to achieve it on the frontend...

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

BLOX TABLE WITH HYPERLINKED URL

 I am trying to create a dashboard that contains a Blox widget with custom hyperlinked resources in it. This was what I came up with. Does anyone have a better idea/suggestions for achieving this?   { "style": "", "script": "", "titleSty...

cartercjb_0-1648527528310.png

Pivot Table widget - column headers and column data out of alignment

I am seeing odd behavior in a pivot table widget.  This is a widget that has been in production for some time, and it gets updated once a week with a new batch of data.  This week, for the first time, the column headers are out of alignment with the ...

Screenshot 2022-03-25 120856.png
Amy by 7 - Data Storage
  • 2376 Views
  • 2 replies
  • 0 kudos

Wrapping text in pdf export of pivot

Hello Community,  i am looking for a solution of wrapping text in pivot pdf export. By using the below code i am able to wrap text in dashboard but not in pdf.  this.afterResultLoaded = function (args) {$('table', args.element).css('table-layout', ''...

Chandra by 8 - Cloud Apps
  • 1493 Views
  • 0 replies
  • 0 kudos

Stopping an RSUM after its last value

When using RSUM over a category, and when the RSUM has underlying values only for some early periods of time, and not later periods, it sums in the NULLs from those future periods showing values extending into the future. I do want the RSUM to be con...

wallingfordce_0-1648057720496.png

Resolved! Lines on scatter chart

This seems like a very trivial question, but I couldn't seem to find an answer. If I have a scatter chart, I would also like to show the calculated average of the x- and y-axis spanning across the chart. For example if the average of the points on th...

taek_onvi by 8 - Cloud Apps
  • 4524 Views
  • 6 replies
  • 0 kudos

PDF Header Elements

Hello!I'm looking to play around with the Dashboard Header parameters. More specifically, I'd like to do the following: 1. Truncate the Data As Of parameter to the day (aka remove timestamp) 2. Play around with the display of the Dashboard Filters. F...

Sub column Headers in Pivot Table

I am trying to achieve a pivot table format, where there are multiple column headers under one. I am attaching the screenshot for the format here. As the fields are text and date fields, i am not able to achieve that format directly through the pivot...

HemaK by 7 - Data Storage
  • 1384 Views
  • 0 replies
  • 1 kudos

Convert pie chart to semi-circle donut

Here is a script to convert pie chart to semi circle donut     widget.on('processresult', function(se, ev){ ev.result.plotOptions.pie.startAngle= -90, ev.result.plotOptions.pie.endAngle= 90, ev.result.plotOptions.pie.center= ['50%', '85%...

harikm007_0-1646895212649.png
harikm007 by 13 - Data Warehouse
  • 5106 Views
  • 10 replies
  • 1 kudos

BLOX WIDGET: PIVOT INSIDE A PIVOT

I have the following blox widget:     with the following code: { "style": ".blox-slides:not(:first-child) .blox-pivot-title{display:none} .blox-slides .blox-pivot-title{margin-bottom:10px; font-weight:bold; color:black; font-size:1em}", "sho...

cartercjb_1-1647629460323.png cartercjb_2-1647629509001.png cartercjb_6-1647629674234.png cartercjb_5-1647629627259.png

Resolved! ADD SPARKLINE TO INDICATOR BLOX

Here is a current screenshot of my current blox widget:  I made this starting from a default template that was available in my library (ref the attached STARTING TEMPLATE BLOX.JSON).   For each of the 3 KPI's my goal is to add a trending sparkline w...

cartercjb_0-1644420999374.png
Check out our Software Developer Communities!