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

Forum Posts

BLOX widget script level CSS changes

I have custom dashboard level script to style widget borders/headers: dashboard.on('widgetready', function(d){ $('.widget').css('border-radius','10px').css('border', '#c8c8c8 solid 1px'); $('widget-header').css('background-color','#f2f2f2').css('heig...

ElementUX_0-1652978095479.png
ElementUX by 8 - Cloud Apps
  • 2202 Views
  • 3 replies
  • 0 kudos

Drill down from one dataset(sql table 1) to another(sql table 2).

I am fairly new to sisense. I have this situation as below: I have connected sisense to a "Sample Sales" SQL Server Database with 2 Tables: Database : Sales_db Tables : tb_sales_summary : 2. tb_sales : In Sisense I have done an inner join on these tw...

reema_2-1652970547535.png reema_3-1652970630446.png reema_0-1652973075464.png
reema by 7 - Data Storage
  • 3206 Views
  • 5 replies
  • 0 kudos

Column Chart - Reorder X-Axis

When creating a column chart you'd sometimes want to reorder the category fields Apply the following widget script: widget.on('processresult', function(widget,result) { // Wanted Order let order = ['New','Used','Refurbished','Unspecified'] // For eac...

Ophir_Buchman_0-1652946574383.png Ophir_Buchman_1-1652946592071.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Formula not producing correct results

I am attempting to replace a value of N/A with another field in a table. I continue to receive the value of "N/A" which is in the "Working Title" field with the formula below. Is this the appropriate formula? The actual value that appears in the work...

BLOX EQUAL & DYNAMIC SPACING

I have the following BLOX widget: Which is generated via this BLOX code: { "style": "", "titleStyle": [ { "display": "none" } ], "script": "[].slice.call( document.getElementsByClassName('blox-date') ).forEach(function ( div ) { div.innerHTML = new D...

cartercjb_0-1652810819890.png

Using Google Ads connector for EC models with CDATA Driver

The Google Adwords native connector is no longer supported because they use Google APIs that are no longer supported by Google.New installations from 2022.5 and up will no longer contain the Google Adwords native connector. Note: The CDATA table/colu...

guyraz_0-1652802810366.png guyraz_2-1652802810349.jpeg guyraz_3-1652802810339.png
GuyRaz by Sisense Team Member
  • 1958 Views
  • 0 replies
  • 0 kudos

Resolved! PREVENT EXPORTS

I have two questions after searching through the community: HOW DO YOU PREVENT A WIDGET FROM BEING DOWNLOADED? HOW DO YOU PREVENT USERS FROM EXPORTING AN ENTIRE DASHBOARD TO PDF?

cartercjb_0-1652723644237.png cartercjb_2-1652723716527.png

Sorting Blox pivot table based on alphabetical order

Here in this link(https://support.sisense.com/kb/en/article/blox-sort-values-action) they have sorted the table in numerical and We wish to sort based on alphabetical order Anything related to it would be very much help.

Column Chart - Rename Categories/Break-By

When creating a column chart you'd sometimes want to rename the categories/break-by fields Modify the "Break-By" Category Names Apply the following widget script: widget.on('processresult', function(widget,result) { // Translation Dictionary let dict...

Ophir_Buchman_4-1652684842117.png Ophir_Buchman_5-1652684857959.png Ophir_Buchman_6-1652684910083.png Ophir_Buchman_7-1652684926006.png

Bar Chart - Rename Categories/Break-By

When creating a bar chart you'd sometimes want to rename the categories/break-by fields Modify the "Break-By" Category Names Apply the following widget script: widget.on('processresult', function(widget,result) { // Translation Dictionary let dict = ...

Ophir_Buchman_0-1652640891727.png Ophir_Buchman_1-1652640905222.png Ophir_Buchman_2-1652640949007.png Ophir_Buchman_3-1652640966095.png

Set marker symbol for each category in line chart

Different marker symbols can be set to line chart based on its value (Y-axis) using this script. But in some cases we may need to set icons for each category (X-axis), Here is a script to achieve this https://www.binextlevel.com/post/set-marker-symbo...

harikm007_0-1652432448238.png
harikm007 by 13 - Data Warehouse
  • 1129 Views
  • 1 replies
  • 3 kudos

Resolved! How do I sum if or count if using conditional values?

Hi Community, I'm trying to figure out why my pivot table is returning incorrect values, and how to fix it.I need a variety of formulas that apply to each program in my pivot table to collect data about how much money we are contracted to receive, ho...

oliviar_7-1652199331670.png oliviar_8-1652199384350.png oliviar_1-1652198307796.png oliviar_2-1652198431447.png
oliviar by 7 - Data Storage
  • 3770 Views
  • 3 replies
  • 0 kudos

Resolved! Dynamic Sparkline Width

Hi, I have 2 questions about formatting sparklines in BloX. 1. Is there a way to make the width of the sparkline dynamic, rather than hard coding it? 2. How can I remove all the white space above my first textblock? I have the margin-top set to zero ...

gwolfe_0-1652134864712.png
gwolfe by 10 - ETL
  • 1718 Views
  • 2 replies
  • 0 kudos

Resolved! Tracking previous months data alongside current month

  Morning! Is there a way that I can track the previous month's exceptions alongside the current month? The left widget is working as intended with the max value listed being the total exceptions of the previous month, and the ~46k is the current exc...

Screenshot 2022-05-09 113835.png
zfesler by 7 - Data Storage
  • 2715 Views
  • 4 replies
  • 0 kudos
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]