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

Forum Posts

Error: "Live models can have only one dataset"

I clicked "Duplicate As Live". I got an error "Live models can have only one dataset".I made sure I only have one dataset (see left side of picture below). So why am I getting the error?I did refresh schema on all tables, and made sure they all point...

Tim_0-1684464722627.png
Tim by 9 - Travel Pro
  • 757 Views
  • 3 replies
  • 0 kudos

Re-Order Pivot table Items

Hi, I have a pivot table where there are various areas listed 1-15 but it will order it by the first number in the series ie. 1, 10, 11, 2 , 3Is there a way around this so it will read 1, 2 , 3... 10 , 11

Juandres_0-1684409056397.png
Juandres by 8 - Cloud Apps
  • 499 Views
  • 0 replies
  • 0 kudos

center align all widgets in dashboard

dashboard.on('widgetready', function (se, ev) {// Widget IDsvar widgetIds = ['645216bac5715a00355a81b5', '645cc852c5715a00355b12ec', '64631a30c5715a00355b35c6',"646339bcc5715a00355b365f","64633ac6c5715a00355b3668","64633bd5c5715a00355b367b"]; // Add ...

customize widget backround and header

dashboard.on('widgetinitialized', (el, args) => {$('widget-header').css('background-color', '#E8E8E8').css('font-weight', 'bold');$('.widget-title__holder').css('font-size', '16px');});

Conditionally format a measure based on another measure

Sometimes we would like to color code a measure (A) not by its performance rather by another measure's (B) performance. The problem is that when applying the conditional formatting on measure A, the measure A is static in the equation. To work around...

111.png
Ido_QBeeQ by 9 - Travel Pro
  • 406 Views
  • 0 replies
  • 2 kudos

Rank based on each month

Hi @Angelina_QBeeQ ,I want to set the rank independently for each month based on measure.Rank logic: RANK([Overall Vol],"1224",[l3_demand],[Months in contact_date])As per below sc, rank shd be 1,2,3....for Mar and similarly 1,2,3...for Feb and so on....

tsaho8_0-1684222544910.png
tsaho8 by 7 - Data Storage
  • 923 Views
  • 4 replies
  • 0 kudos

Resolved! How do i disable toggle switch button in filterpane?

Hi,For my dashboard, I would like to disable or delete the toggle switch buttons in the filter pane (shown in the picture), so the users of the dashboard do not have the option to turn them on or off.I can't seem to find the option in menus. Is it po...

frankmol_0-1684152551795.png
frankmol by 8 - Cloud Apps
  • 1320 Views
  • 4 replies
  • 0 kudos

Resolved! Reorder columns in pivot table

Hi Team,@Angelina_QBeeQI want to order the weeks displayed in below pivot in desc order i.e latest week first and so on.Also how to hide the "Header" word....i need the column but the column header should be blank.Please help !!

gyanianand_0-1684134616028.png

Change Blox Dynamic Pivot Table Header

I have created a Blox Dynamic Pivot Table that I have transposed so that the columns are months and the rows are calculated values. I would now like to update the table so that the month displayed in each column is actually the next month (e.g., Apri...

ebambury by 8 - Cloud Apps
  • 1029 Views
  • 1 replies
  • 0 kudos

Table Join

I'm having an issue joining two tables an suspect it's due to the integer value within the tables. In SQL, I'd join like this:SELECT top 1000 * FROM tblOrderRouteStops R WITH(NOLOCK)INNER JOIN tblOrderRouteStopsParcelAssigned PA WITH(NOLOCK)ON R.PKID...

Changing fontsize in pivot2 breaks PDF-export

Hey,So I used the following widgetscript to alter the font in a pivot-table. In the dashboard these alterations are visible, however when exporting it to PDF the pages are all blank. widget.transformPivot( {}, function (metadata, cell) { cell.style =...

HamzaJ by 12 - Data Integration
  • 458 Views
  • 1 replies
  • 0 kudos
Community Toolbox

Recommended quick 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]