javierecfpn
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Custom PDF Export Script - Fit to 1 Page
I don't know if it is possible with a custom script but you can play a little bit with the size of the paper to see if it fits more widgets, for instance we use Legal (216mm x 356mm) and Landscape orientation and it mostly works for most dashboards, if you really need to fit everything inside a portrait letter size page I would recommend doing a script that exports PNG files from every widget using the API and then fits them into a single PDF page as best as possible using your own criteria.4KViews1like0CommentsRe: Table Widget Format Header Row
Sadly this is not very well documented but you can do a lot of cool stuff with JS inside the widgets, my advice would be to play a little bit with the classes of the rows and cells inside the <widget> object on the page, this will for example change the color for the headers and center align its text (just to give you an idea you will probably modify it to do something else as it fits you) note: only for pivot tables widget.on('domready', function(se, ev) { //change color of header cells $(".table-grid__row.table-grid__row-0 .table-grid__cell", element).css("background", "cyan"); //change width % of columns //$(".table-grid__row.table-grid__row .table-grid__cell", element).css("width", "100%"); //$(".table-grid.table-grid--data", element).css("width", "100%"); //center align $(".table-grid__row.table-grid__row-0 .table-grid__cell .table-grid__content", element).css("text-align", "center"); }); Also I would recommend just reading more inside the Pivot 2 API and what can be done in JS, as you can do the thing I just mentioned in JS and much more and it would be more natural for the widget https://sisense.dev/reference/js/widget/pivot2.html9.1KViews1like5CommentsRe: Table Widget Format Header Row
I tested this with version L2021.10.0.124 on Linux, but with a pivot table, now that I see more clearly you are using a normal table, try this widget.on('domready', function(se, ev) { //change color of header cells var cols = $(".dataTable.no-footer tr th", element); cols.css("background", "cyan"); //change width of columns cols.css("width", "200px"); //center align cols.css("text-align", "center"); });9.2KViews2likes3CommentsRe: Parsing a string
As far as I know there is no built in split function which is what you need, but you can get a similar behavior using the text manipulation functions that are provided select strbetween(strparts(x, ',', 1),'[','|') x, strbetween(strparts(x, ',', 1),'|',']') y, 1 as pos from ( select replaceAll('[1,"0"],[16,"8938473"],[17,"0"],[21,"*"]', ',"', '|"') as x )dt union all select strbetween(strparts(x, ',', 2),'[','|') x, strbetween(strparts(x, ',', 2),'|',']') y, 2 as pos from ( select replaceAll('[1,"0"],[16,"8938473"],[17,"0"],[21,"*"]', ',"', '|"') as x )dt see: https://support.sisense.com/kb/en/article/split-a-delimited-field-into-rows for another example4.2KViews1like1CommentRe: Empty filter at initial load in Linux version?
if you have a text column and you do a text filter in it, you can specify the way the text is filtered at start, the only thing they need to do is change the filter value to something else after (see attachment) But I think the best way to do it is to narrow down the values that are on your Terms table by doing a segregation on the data security for the cube, that way only users that have access to those terms will be able to see them and you can use the "Include All" functionality as normal. see: https://documentation.sisense.com/docs/data-access-security for more info on data access security2KViews0likes0CommentsRe: Conditional Coloring based on PIVOT Dimension (not value)
First disable alternative rows on the pivot table then you can do this (it works but just to give you the idea) widget.on('domready', function(se, ev) { //data grid var rows = $('.pivot-container .table-grid--data .table-grid__row', element).not('.table-grid__row-0'); //get all the cells of the column var ix = 0; rows.each(function() { do_row($(this), ix); ix++; }); function do_row(row, ix){ var color = 'cyan'; var row_el = $(row); var c0 = row_el.find('.table-grid__cell--col-0 .table-grid__content__inner'); //name var c1 = row_el.find('.table-grid__cell--col-1 .table-grid__content__inner'); //value if(c1.text() == '1,001'){ console.log(c1.text(), color) //change the color of the row row_el.css("background-color",color); //fixed grid $('.pivot-container .table-grid--fixed .table-grid__row-' + (ix + 1)).css("background-color",color) } } }); This will do bg color for the entire row, beware of pagination as the row has not been rendered yet this may not work.7.2KViews1like1CommentRe: Is there any way to convert a string to a number?
You can have a custom table that converts the field to number, the values that are not possible to be converted are just gonna be empty (null) select todouble(quantity) from ( select 'AA1' as quantity union all select '29228' union all select '0001' union all select 'xxa$%#1' ) dt7.8KViews1like0Comments