lharrison
Cloud Apps
Joined 11-03-2021
User Profile
User Widgets
Contributions
Default Condition on BloX?
I am using the conditions feature on BloX cards. Here is an example: "conditions": [ { "minRange": "-Infinity", "maxRange": -0.01, "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" } ] This works well, but if the value is null, it renders unpredictably. What I'm looking for is a conditional for when the value is null. Does anyone know how to go about this?Newer version of Highchart?
There are features in the more current versions of Highchart that I want to be able to use. It looks like our server is on Highcharts v6.0.4. Does Sisense intend to move to a more modern version? Or is this something that we can upgrade ourselves?Solved2.6KViews0likes4CommentsYear-To-Date for Only Completed Months
Hello, I have a pivot table where I am calculating YTD vs. LYTD metrics by month, like this: I want to exclude April from this table as it is not a completed month and thus doesn't provide useful information. I can't figure out how to do that from the filters pane and haven't had any luck with scripts either. Does anyone have any ideas?SolvedResizing widgets past their size limits
Hello. When using tables with aggregation, I often want to display a single row of data. The widget won't let me reduce the height enough to get rid of all the white space (see below). This is the minimum height of the widget. I would like to be able to make the widget exactly as tall as it needs to be to show that single line table. Is there a way I can do this through scripts?Solved6.5KViews0likes6CommentsRe: Conditional Coloring based on PIVOT Dimension (not value)
You can use something like this (Windows Sisense): widget.on('ready',function(){ var valueToFind = 'Value' var containingRow = $('td.p-dim-member[fidx="1"] div').filter(function(){ return $(this).text().toUpperCase()==valueToFind.toUpperCase(); }).closest('tr'); containingRow.css({'background-color':'orange'}); }) Replace the valueToFind with what you're looking for and replace fidx="1" with the column number beginning at 0. Note that this will only work on dimensions, values are different. If you want to just highlight the individual box (so not the whole row) replace closest('tr') with closest('td').7.2KViews1like1CommentRe: Leveraging Usage Analytics for maintaining a healthy environment
It needs to be noted that the 'last opened' field on the dashboards API call is only for the owner. If anyone other than the owner accesses the dashboard, this date is not updated. Please edit this post to include this information - this is not a reliable way to gauge if a dashboard is in use. If there is some way to account for this and get a true last opened date, please let me know.1.5KViews0likes0CommentsRemove 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.3KViews2likes2Comments