Pivot Table widget - column headers and column data out of alignment
I am seeing odd behavior in a pivot table widget. This is a widget that has been in production for some time, and it gets updated once a week with a new batch of data. This week, for the first time, the column headers are out of alignment with the data columns. When I filter the data, the issue disappears in most cases, so I think it must be caused by something weird in the new batch of data (maybe an unexpected or invisible character, or a new combination of the dimensions), but I haven't been able to pinpoint any bad data yet. Even if it is a problem with the data, the behavior in Sisense seems strange so I thought I would post a question here, in case anyone has encountered a similar issue. Attached is a screen shot. The widget on top is a pared down version of the widget in production that demonstrates the issue. The two widgets on the bottom show that the issue is resolved with some tweaks to the dimensions/rows. Any thoughts would be appreciated. Thanks!3.1KViews1like3CommentsBlox conditional formatting up and down indicators
Hi, I currently have conditional formatting for a blox widget. Based on the percentage change, it changes the font color (green or red) and a up or a down arrow. However, instead of the arrows I want a textblock with a background color. I tried taking a stab at it but it's changing the entire widget color. Attaching my current CSS snipet. Thank you { "style": "", "script": "", "title": "", "showCarousel": false, "conditions": [ { "minRange": "-Infinity", "maxRange": 2000, "backgroundColor": "#fd6e69" }, { "minRange": 2000, "maxRange": 10000, "backgroundColor": "#FAA0A0" }, { "minRange": 10000, "maxRange": "Infinity", "backgroundColor": "#3adcca" } ], "body": [ { "type": "ColumnSet", "columns": [ { "type": "Column", "spacing": "small", "items": [ { "type": "ColumnSet", "height": "40px", "style": { "border-radius": "6px 6px 0px 0pc", "background-image": "linear-gradient(330deg, #F7941D 10%, #703971)", "box-shadow": "1px 1px 2px #a6a4a4" }, "columns": [ { "type": "Container", "style": {}, "items": [ { "type": "TextBlock", "id": "", "class": "", "text": "Accounts Receivable", "horizontalAlignment": "left", "style": { "color": "#edeef0", "font-weight": "500", "font-size": "12px", "margin": "15px 0px 15px 10px" } } ] }, { "type": "Image", "id": "", "class": "", "url": "https://www.svgrepo.com/show/419269/avatar-human-person.svg", "altText": "image descriptions", "style": { "margin": "0px 10px", "width": "20px" } } ] }, { "type": "Container", "style": { "background-color": "#FFFFff", "margin-bottom": "1px", "border-radius": "0px 0px 6px 6px", "box-shadow": "1px 1px 10px #a6a4a4" }, "items": [ { "spacing": "none", "type": "ColumnSet", "columns": [ { "spacing": "medium", "separator": "true", "type": "Column", "items": [ { "type": "TextBlock", "horizontalAlignment": "left", "text": "Total", "weight": "bold", "color": "grey", "size": "medium" }, { "type": "ColumnSet", "columns": [ { "type": "Column", "style": { "flex-grow": "0" }, "items": [ { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:Total AR_AMOUNT}", "weight": "bold", "color": "#232a2f", "size": "large", "style": { "margin": "0px" } } ] }, { "spacing": "small", "type": "Container", "items": [ { "type": "Image", "class": "conditional_image", "size": "small", "spacing": "none", "horizontalAlignment": "center" } ] }, { "spacing": "none", "type": "Container", "style": { "flex-grow": "100" }, "items": [ { "spacing": "small", "type": "TextBlock", "class": "condition_data", "text": "5000%", "horizontalAlignment": "center", "size": "small", "weight": "bold", "color": "red" } ] } ] }, { "type": "TextBlock", "horizontalAlignment": "left", "text": "Insurance", "weight": "light", "color": "grey", "size": "small", "spacing": "none" }, { "type": "ColumnSet", "columns": [ { "type": "Column", "style": { "flex-grow": "0" }, "items": [ { "spacing": "small", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:AR_insurance}", "weight": "bold", "color": "#232a2f", "size": "medium", "style": { "margin": "0px" } } ] }, { "type": "Column", "items": [ { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "2.5%", "weight": "bold", "color": "#232a2f", "size": "small", "style": { "margin": "10px 0px 0px 30px" } } ] }, { "type": "Column", "style": { "flex-grow": "100" }, "items": [ { "type": "Image", "class": "conditional_image indexsp-stock", "url": "/plugins/BloX/blox-images/StockMarket/arrow-up.png", "style": { "margin": "0px 0px 0px 0px" }, "size": "small", "spacing": "none" } ] } ] }, { "type": "TextBlock", "horizontalAlignment": "left", "text": "Patient", "weight": "light", "color": "grey", "size": "small" }, { "type": "ColumnSet", "columns": [ { "type": "Column", "style": { "flex-grow": "0" }, "items": [ { "spacing": "small", "horizontalAlignment": "left", "type": "TextBlock", "text": "{panel:AR_patient}", "weight": "bold", "color": "#232a2f", "size": "medium", "style": { "margin": "0px" } } ] }, { "type": "Column", "items": [ { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "-4%", "weight": "bold", "color": "#232a2f", "size": "small", "style": { "margin": "10px 0px 0px 30px" } } ] }, { "type": "Column", "style": { "flex-grow": "100" }, "items": [ { "type": "Image", "class": "conditional_image indexsp-stock", "url": "/plugins/BloX/blox-images/StockMarket/arrow-down.png", "style": { "margin": "0px 0px 0px 0px" }, "size": "small", "spacing": "none" } ] } ] }, { "type": "TextBlock", "horizontalAlignment": "left", "text": "Other", "weight": "light", "color": "grey", "size": "small" }, { "type": "ColumnSet", "columns": [ { "type": "Column", "style": { "flex-grow": "0" }, "items": [ { "spacing": "small", "horizontalAlignment": "left", "type": "TextBlock", "text": "$0", "weight": "bold", "color": "#232a2f", "size": "medium", "style": { "margin": "0px" } } ] }, { "type": "Column", "items": [ { "spacing": "none", "horizontalAlignment": "left", "type": "TextBlock", "text": "0%", "weight": "bold", "color": "#232a2f", "size": "small", "style": { "margin": "10px 0px 0px 30px" } } ] }, { "type": "Column", "style": { "flex-grow": "100" }, "items": [ { "type": "Image", "class": "conditional_image indexsp-stock", "url": "/plugins/BloX/blox-images/StockMarket/arrow-down.png", "style": { "margin": "0px 0px 0px 0px" }, "size": "small", "spacing": "none" } ] } ] } ] } ] } ] } ] } ] } ] }4.6KViews0likes3Comments
Remove Widget Title Box
Hello. Is there any way to remove the title portion of a widget? I often don't place a title on indicator widgets, but the title box still limits how small the widget can be and leads to some awkward white-space. Is there any way to get rid of the box and the white-space that comes with it?Solved7.2KViews2likes2Comments
Rename the Pivot Grand Total
Hi Team, I saw a couple of scripts/solutions to rename the Grand Total in the Pivot table however, nothing seems to work maybe due to Linux enironment. Can you help me rename the Grand Total. Also, is there a way, I can use this Grand Total for any other widget formula. Thanks Ido_QBeeQ harikm0071.5KViews0likes1Comment
Line Chart - Customizing a line to various "Dotted" styles
When creating a line chart, a certain line might require a different style. For example - A line that shows a threshold should be styled as a dotted line The following widget & widget script can be used to customize your line chart: widget.on('processresult', function(widget, result) { let series = result.result.series; series[1].dashStyle = 'Dot' }) Result: Before After Available line styles: Solid ShortDash ShortDot ShortDashDot ShortDashDotDot Dot Dash LongDash DashDot LongDashDot LongDashDotDot'2.2KViews4likes1Comment
Hide First Column in Table and/or Pivot when exporting to Excel or CSV
Requirement: Append table to website so that user can view and download to csv. Export should be in pivot table format. Export should contain data on individual lines and not grouped. Steps to accomplish: Added index column to remove grouping. Now I need help removing the index column when downloading. Here is a sample table. When I export to csv or excel from a pivot I would like to exclude the index column. Any suggestions? Index Name State Amount Units Total 1 Mickey GA $ 5.00 1 5 2 Mickey GA $ 5.20 2 10 3 Mickey GA $ 7.00 4 20 4 Minnie GA $ 5.00 8 40 5 Daisy GA $ 6.99 7 48.93 6 Goofy FL $ 4.32 9 38.881.5KViews0likes4Comments
Formatting Percentages in Pie Charts
Hello. How do you format the number of decimal points in a pie chart (widget) on my Periscope Dashboard? Within my chart, the chart displays percentages down to the thousandth place; which overwhelms my Evaluator. Any advice would be appreciated.2.1KViews0likes2Comments
Line Chart - Customizing a line to various "Dotted" styles
When creating a line chart, a certain line might require a different style. For example - A line that shows a threshold should be styled as a dotted line The following widget & widget script can be used to customize your line chart: widget.on('processresult', function(widget, result) { let series = result.result.series; series[1].dashStyle = 'Dot' }) Result: Before After Available line styles: Solid ShortDash ShortDot ShortDashDot ShortDashDotDot Dot Dash LongDash DashDot LongDashDot LongDashDotDot'
