Usually, when you want to color categories, you would use "break by", but then you cannot have two values on the same graph:I needed to show past year's values (grey on the left widget bellow) but on the same time color the categories like they are o...
Hello all, I noticed that the Color Heatmap widget ignores filters that are based on the same fields that are used in the widget's configuration. When this occurs, the widget's color is diluted (presumably to show that it has been filtered). For exam...
Hi all, I have an issue that could be easy to solve but I'm not getting the answer. I'm able to implement filters as BloX dropdown list (unique/multi selection), but the issue is that when I choose a value of the list, the filter it's appplied and, t...
Is there any way to freeze the header row in a pivot table, when the number of rows is very high it is difficult for users to scroll up and see what each column refres to
IS THERE A SCRIPT TO ENABLE VERTICAL SCROLLING FOR A LONG TEXT WIDGET?
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 th...
When creating a column chart you might want to add a percentage value next to the actual value Add the following script to your widget: widget.on('processresult', function(widget,result) { result.result.plotOptions.series.dataLabels.formatter = funct...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
I have the following pivot: Why does the RSUM show a value of $0 on 4/3 instead of (92+428+0)? Thanks! -Carter
I am running into a problem with BloX when transitioning from a large monitor to a laptop where text gets cut off. Is there a way I can make font size dynamic? This looks fine on a monitor.. But when I move to a laptop... Thanks,
Hi, We are looking for color gradient in Pivot table, but we couldn't find any range option in color formatting and also we tried widget scripts but its not effecting in widget. Is there any alternate solutions? I have attached the screenshot for ref...
Hi Team, We have specific requirement where we need to have same column (table.column) for two different filters. we are using dropdown list to show names based on set of IDs(dashboard filter) and when we select a name from the drop list we need filt...
I have the following script that modifies the values within a couple columns in this table widget and it works just fine. The issue I am having is it only applies to the first page of the table, and as soon as I change the page the changes are no lon...
When creating a line chart, the X-Axis of the chart may require customization (e.g., number of labels, the format of labels, special handling of first/last values, etc.) Scenario #1 - Reducing the number of labels (by half) Add the following script t...
Does anyone have suggestions on how to change the layers in which the values are plotted? I have this chart where the data label shape for RUNNING 14-D AVG. is behind the Column: I tried re-arranging the Values, which does fix the layering problem, b...
Hi, does anyone knows how to get color for category from Database? For every category our customers has their own colours, so I would like to display them in my Pie Chart component. Thanks.
