CONDITIONAL CASE SUM
Hi Sisense Community!! Please reference the attached workbook that I drafted in Excel. I am trying to draft a daily view by week, of each employee's time worked. This screenshot shows an example of actual hours worked by day by employee. I am trying to create a dynamic case statement for a metric that calculates the same way as is seen in K7 in the workbook. Essentially it would ready like this: SUM(TIME ON SUNDAY) + IF (TIME ON MONDAY = 0 THEN 0 ELSE TIME ON MONDAY) + IF(TIME ON TUESDAY = 0 THEN 0 ELSE TIME ON TUESDAY) + IF(TIME ON WEDNESDAY = 0 THEN 0 ELSE TIME ON WEDNESDAY) + IF(TIME ON THURSDAY = 0 THEN 0 ELSE TIME ON THURSDAY) + IF(TIME ON FRIDAY = 0 THEN 0 ELSE TIME ON FRIDAY) Any suggestions on how to get this case statement started through the first two lines? Many thanks in advance! -CarterSolved16KViews1like16CommentsDYNAMICALLY FORMATTED DATA LABELS
Does anyone have suggestions on how to do the following: Script the data labels so that they never overlap? I'm not sure if that's possible but I can hope! Add additional formatting around the data labels similar to the screenshot below where each data label is surrounded in a colored shape?Solved10KViews1like12CommentsCustom Pivot Table Formatting Script
Does anyone know how to update this widget script to achieve the DESIRED format I have outlined in the screenshot? Essentially, I'm looking to make each subsequent row total a different color, rather than all the same. CURRENT SCRIPT CODE 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-grand-total-head,.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'); //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); }) Thank you!7.1KViews0likes8CommentsCOLUMN 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!!!Solved6.5KViews0likes4CommentsDEFAULT TABBER SELECTION
I have the following tabber created: Is there a way to dynamically set the default selection so that when the dashboard opens, it opens to the correct day? So if I were to open it today, it would select Monday. If I were to open this on a Wednesday, it would select Wednesday. widget.tabs = [ {title: "MONDAY", displayWidgetIds : [],hideWidgetIds : []}, {title: "TUESDAY", displayWidgetIds : [],hideWidgetIds : []}, {title: "WEDNESDAY", displayWidgetIds : [],hideWidgetIds : []}, {title: "THURSDAY", displayWidgetIds : [],hideWidgetIds : []}, {title: "FRIDAY", displayWidgetIds : [],hideWidgetIds : []}, ];Solved6.4KViews1like8CommentsBLOX 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
