cartercjb
ETL
Joined 5 years ago
User Profile
User Widgets
Contributions
COLUMN CHART SHOW ALL CATEGORIES EVEN IF NULL/0/MISSING
Please reference the attached excel worksheet. My goal is to show all horizontal categories, even when data = null/0/N/A. Currently, only 3/6 categories appear and I've tried nearly every Sisense KB article I can find related to null/N/A values. THANK YOU!!!SolvedJUMP TO PIVOT CELL COLOR FORMAT
I have the following code that formats the pivot table seen below: widget.on("ready",function(w, args) { var headerBgColor = '#a90a40'; //Header background var headerFontColor = '#F2F3F2'; //Header Font Color var footBgColor = '#44546A'; // Pivot Foot (Totals) var footFontColor = '#F2F3F2'; // Pivot Column (dims) var colFontColor = '#5690a2'; // Style var $jx = $(".p-dim-head,.p-dim-member-head,.p-measure-head", element); $jx.css('font-size' , '12px'); $jx.css('font-weight' , 'bold'); $jx.css('color' , headerFontColor); $jx.css('background-color' , headerBgColor); $jx.css('text-align' , 'center'); $jx.css('vertical-align' , 'middle'); // GRAND TOTAL var $jx = $(".p-grand-total-head,.p-grand-total-row-head,.p-grand-total-val", element); $jx.css('font-size' , '12px'); $jx.css('font-weight' , 'bold'); $jx.css('color' , headerFontColor); $jx.css('background-color' , headerBgColor); $jx.css('text-align' , 'left'); $jx.css('vertical-align' , 'middle'); //center values and col $(".p-value", element).css('text-align', 'center'); $(".p-dim-head", element).css('text-align', 'left'); // row totals var $jx= $(".p-total-row-val,.p-total-row-head", element); $jx.css('font-size' , '12px'); $jx.css('font-weight' , 'bold'); $jx.css('color' , footFontColor); $jx.css('background-color' , footBgColor); $jx.css('border-top', 'none'); // col var $jx = $(".p-dim-member", element); $jx.css('font-size' , '10px'); $jx.css('font-weight' , 'bold'); $jx.css('color' , colFontColor); $jx.css('text-align' , 'left'); var $jx = $(".p-value", element); $jx.css('font-size' , '10px'); // boarders var $jx = $("[fidx]", element); $jx.css('border-bottom', 'thin solid ' + colFontColor); $jx.css('border-right', 'thin solid ' + colFontColor); }) Is there a way to update the script to target the font color of all the values (which are blue)? All of these values are blue because the Jump to dashboard feature is enabled.1.5KViews0likes0CommentsBLOX 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 Date().toLocaleDateString(); })", "title": "", "showCarousel": true, "carouselAnimation": { "delay": 0, "showButtons": false }, "conditions": [ { "minRange": "-Infinity", "maxRange": 0, "color": "#FA5656", "image": "/plugins/BloX/blox-images/StockMarket/arrow-down.png" }, { "minRange": 0, "maxRange": "Infinity", "color": "#54a254", "image": "/plugins/BloX/blox-images/StockMarket/arrow-up.png" } ], "body": [ { "spacing": "", "type": "Container", "width": "100%", "style": { "margin": "0 auto" }, "items": [ { "type": "TextBlock", "text": "FINANCIAL KPI'S | RUNNING WEEKLY TREND", "class": "blox-pivot-title", "horizontalAlignment": "center", "size": "medium", "style": { "padding": "2px", "border-radius": "5px", "background-color": "#006374", "color": "#ffffff" } }, { "type": "ColumnSet", "class": "condition_container ", "columns": [ { "type": "Column", "items": [ { "spacing": "small", "type": "TextBlock", "text": "REVENUE", "horizontalAlignment": "center", "weight": "bold", "size": "small", "style": { "color": "#000000" } }, { "type": "ColumnSet", "class": "condition_container ", "columns": [ { "type": "Column", "items": [ { "type": "TextBlock", "text": "{panel:REVENUE}", "horizontalAlignment": "center", "weight": "bold", "size": "large", "style": { "color": "#a90a40" } } ] } ] }, { "type": "ColumnSet", "class": "condition_container", "columns": [ { "type": "Column", "items": [ { "type": "TextBlock", "text": "<span class='blox-sparkline' type='line' line-color='#006374' width='200' height='30' line-width='2' fill-color='#B2D4DF' point-color:'#A90A40'>{spark:-21REVENUE},{spark:-14REVENUE},{spark:-7REVENUE}</span>", "horizontalAlignment": "center", "weight": "bold", "size": "small", "style": { "color": "#117899" } } ] } ] }, { "type": "ColumnSet", "columns": [ { "type": "Column", "items": [ { "type": "TextBlock", "text": "BUDGET:", "style": { "text-align": "left", "font-size": "small", "font-style": "", "color": "#d5d5d5" } }, { "type": "TextBlock", "text": "FULL MONTH FORECAST:", "style": { "text-align": "left", "font-size": "small", "font-style": "", "color": "#d5d5d5" } } ] }, { "type": "Column", "width": "30%", "items": [ { "type": "TextBlock", "text": "{panel:REV_BUDGET}", "style": { "text-align": "center", "font-size": "small", "font-weight": "regular", "color": "#006274", "font-style": "" } }, { "type": "TextBlock", "text": "{panel:REVENUE_FORECAST}", "style": { "text-align": "center", "font-size": "small", "font-weight": "regular", "color": "#006274", "font-style": "" } } ] } ] } ] }, { "separator": true, "type": "Column", "items": [ { "spacing": "small", "type": "TextBlock", "text": "CONTRIBUTION MARGIN", "horizontalAlignment": "center", "weight": "bold", "size": "small", "style": { "color": "#000000" } }, { "type": "TextBlock", "text": "{panel:CONT. MARGIN $} ({panel: CM%})", "horizontalAlignment": "center", "weight": "bold", "size": "large", "style": { "color": "#a90a40" } }, { "type": "ColumnSet", "class": "condition_container 2", "columns": [ { "type": "Column", "items": [ { "type": "TextBlock", "text": "<span class='blox-sparkline' type='line' line-color='#006374' width='200' height='30' line-width='2' fill-color='#B2D4DF' point-color:'#117899'>{spark:-21CM$},{spark:-14CM$},{spark:-7CM$}</span>", "horizontalAlignment": "center", "weight": "bold", "size": "small", "style": { "color": "#117899" } } ] } ] }, { "type": "ColumnSet", "columns": [ { "type": "Column", "items": [ { "type": "TextBlock", "text": "{panel:CM_BUDGET} ({panel:CMPERC_BUDGET})", "style": { "text-align": "right", "font-size": "small", "font-weight": "regular", "color": "#006274", "font-style": "" } }, { "type": "TextBlock", "text": "{panel:CM_FORECAST} ({panel:CM%})", "style": { "text-align": "right", "font-size": "small", "font-weight": "regular", "color": "#006274", "font-style": "" } } ] } ] } ] }, { "separator": true, "type": "Column", "items": [ { "spacing": "small", "type": "TextBlock", "text": "PRODUCTIVITY", "horizontalAlignment": "center", "weight": "bold", "size": "small", "style": { "color": "#000000" } }, { "type": "TextBlock", "text": "{panel:PRODUCTIVITY}", "horizontalAlignment": "center", "weight": "bold", "size": "large", "style": { "color": "#a90a40" } }, { "type": "ColumnSet", "class": "condition_container 3", "columns": [ { "type": "Column", "items": [ { "type": "TextBlock", "text": "<span class='blox-sparkline' type='line' line-color='#006374' width='200' height='30' line-width='2' fill-color='#B2D4DF' point-color:'#117899'>{spark:PROD_M1},{spark:PROD_M2}, {spark:PROD_M3}</span>", "horizontalAlignment": "center", "weight": "bold", "size": "small", "style": { "color": "grey" } } ] } ] }, { "type": "ColumnSet", "columns": [ { "type": "Column", "items": [ { "type": "TextBlock", "text": "BUDGET:", "style": { "text-align": "left", "font-size": "small", "font-style": "", "color": "#FFFFFF" } }, { "type": "TextBlock", "text": "PREV. MONTH:", "style": { "text-align": "left", "font-size": "small", "font-style": "", "color": "#d5d5d5" } } ] }, { "type": "Column", "items": [ { "type": "TextBlock", "text": "{panel:PROD_BUDGET}", "style": { "text-align": "center", "font-size": "small", "font-weight": "regular", "color": "#006274", "font-style": "" } }, { "type": "TextBlock", "text": "{panel:PRODUCTIVITY -1M}", "style": { "text-align": "center", "font-size": "small", "font-weight": "regular", "color": "#006274", "font-style": "" } } ] } ] } ] } ] } ] } ], "actions": [] } How do I update the BLOX script to equally space each of the 3 KPI's horizontally in an even/equal fashion? The sections highlighted in yellow I feel are not being stretched as far as they could be. The same thing with the trending sparkline - it would be best if that would stretch from border to border. Thanks for your help!2.3KViews0likes1Comment- 2.6KViews0likes0Comments
BLOX DROPDOWN - FILTER OPTIONS
I referenced this KB article to create a BLOX dropdown list as a filter. Here is a screenshot of my dashboard: The BLOX code I used to create the dropdown is at the bottom of this post. I want to filter the available drop down options to only show those that have data associated with them in the charts below. The reason is because the dropdown list contains a ton of available options, most of which result in no data, as seen here: { "style": {}, "script": "", "title": "", "titleStyle": [ { "display": "none" } ], "showCarousel": true, "carouselAnimation": { "showButtons": false }, "body": [ { "type": "Container", "style": { "padding": "15px" } }, { "type": "ColumnSet", "separator": false, "spacing": "default", "columns": [ { "type": "Column", "width": "175px", "items": [ { "type": "TextBlock", "size": "small", "weight": "regular", "wrap": true, "text": "Select Service Code", "style": { "color": "0057B8", "padding-left": "15px", "margin-left": "10px", "backgroundColor": "white" } } ] }, { "type": "Column", "spacing": "none", "width": "175px", "items": [ { "type": "Container", "spacing": "none", "width": "150px", "items": [ { "type": "Input.ChoiceSet", "id": "data.filters[0].filterJaql.members[0]", "class": "", "value": "97110", "displayType": "compact", "choices": "{choices:Service Code}" } ] } ] }, { "type": "Column", "spacing": "none", "width": "175px", "items": [ { "type": "Container", "spacing": "none", "width": "80px", "selectAction": { "type": "sort value", "title": "sort", "data": { "widgetToSort": "625e527ad71ae23f5c342cec", "sortDirection": "desc", "valueIndexToSort": "0" } }, "items": [ { "type": "ActionSet", "margin": "0px", "padding": "0px", "actions": [ { "type": "Filters", "title": "Filter", "data": { "filters": [ { "filterJaql": { "explicit": true, "members": [ "{panel:Service Code}" ] }, "dim": { "title": "Service Code", "table": "Service Type", "column": "Service Code", "datatype": "text" } } ] } } ] } ] } ] } ] } ], "actions": [] }Solved5.8KViews1like2Comments