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

Forum Posts

Column chart to WordCloud

Here is a script to convert a Column chart to WordCloud chart Reference: Create a Column chart. It should contain only one field as category and one Value panel and apply below script. (fun...

harikm007 by 13 - Data Warehouse
  • 5 replies
  • 6 kudos

Week to date as JAQL query

Hi,I am trying to create a jaql query that replicates what I can filter on the dashboard using the UI - filtering a date range to 'This week and last week'. But in the jaql editor, it looks like 'weeks' are not accepted as a date level, so I was wond...

taek_onvi by 8 - Cloud Apps
  • 3 replies
  • 0 kudos

Resolved! Pie Chart, select 1 particular slice and rest are "Others"

Is there a way to select 1 particular slice of a pie chart and move the rest to "Others". By choosing the Select 1 slice option, it picks up the highest value and moves the rest to others. I want to be able to pick another category of the slice.

mirzay by 8 - Cloud Apps
  • 3 replies
  • 0 kudos

Resolved! Pop up on Dashboard Load

Does anyone have a script or a way that I can add a pop-up to a dashboard? Basically, I want a pop-up on dashboard load that says something like : "Updates in progress". This is to alert viewers that there are changes being made.

jmn3 by 9 - Travel Pro
  • 4 replies
  • 0 kudos

Resolved! There is a limit of 8 widgets per row. How can I increase it.

Hi. Im working on new layout of dashboard. I use some small indicators , blox, textboxes etc. and just realized I cannot add widget to row where there is already 8 widgets. This seems to be maximum limit. Is there script or server property I can use ...

Wojtek by 9 - Travel Pro
  • 8 replies
  • 0 kudos

Resolved! How do I display the earliest date as a column in a pivot table?

Hi, I need to create a healthcare pivot table with three columns. Provider Name, number of claims by provider, and earliest date of encounter for each provider. Something like above.. However this being a pivot table is it possible to achieve the las...

hkkwon89 by 9 - Travel Pro
  • 3 replies
  • 0 kudos

Resolved! PDF Output of Pivot - Show all Data

Hi All, Is there a way when using the inbuilt PDF exporter for the Dashboard as a whole that it shows the entire set of data in all the rows and not just 1 page worth? I have tried making it so it isnt paginated but i still only get the first page of...


Debugging: function date_part(unknown, integer) does not exist

When creating a formula in Pivot to get number of days between two date fields, using the DDIFF() function, I get the following message when the widget errors out. function date_part(unknown, integer) does not exist Note, these are date only fields a...

mirzay by 8 - Cloud Apps
  • 0 replies
  • 0 kudos

Sisense Mobile App Formatting

It is possible to write custom scripts to change the formatting of a Blox widget when displaying in the Sisense Mobile App?

mgkirsch by 8 - Cloud Apps
  • 0 replies
  • 0 kudos

Resolved! Add link to widget title

Hello, I have a requirement to add a URL to the widget title so the users will be redirected to a page that will give them more information about the widget data. Can I achieve these 2 things for all widget types ? NOTE : I have already gone through ...

Lisha by 8 - Cloud Apps
  • 5 replies
  • 0 kudos

Report Manager - Custom Templates

The premium Report Manager plug-in has very limited documentation on using Templates. There is a "out-of-the-box look and feel feature" mentioned. Q1) Is this the API Report Manager Template? Q2) Report Manager allows multiple templates to be created...

mirzay by 8 - Cloud Apps
  • 2 replies
  • 0 kudos

Conditional Tooltip based on Date granularity

Hello, I am very new to sisense and have a typical requirement so I am using blox buttons to change the granularity in a widget In the same widget I would like to show comparisons in tooltip for last month, last quarter depending on the granularity s...


Resolved! Grouping Data Into Ranges - Front End

I have a set of data that gives out a Numerical Number for MAX(Score). I want to count the number of each record that falls into a set of ranges. 100-96, 95-90, 89-85, 84-80, 79-75 and <75 My case statement is starting like this: Case When (max([Scor...

Resolved! Using BloX to call Sisense APIs

Hello, Has anybody managed to use a BloX action button to call the Sisense API, such as build ElastiCube? I have tried searching online and see that I need to use type "Action.Submit", action is "post" and provide the url and data parameters. I think...

wforw by 7 - Data Storage
  • 3 replies
  • 0 kudos

Removing widgets from PDF export

Hello!I'm looking for a way (most likely a plugin) to allow Dashboard users (not owners, viewers or designers) to have more editing capabilities when extracting a report as a PDF. Some of our users woudl like to have control over which widget is disp...

Check out our Software Developer Communities!
Community Toolbox

Recommended links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]