ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Notebook - Output data frame to be a selectable option in Cube Thanks all! Much appreciated Re: Notebook - Output data frame to be a selectable option in Cube Thanks Derek, I think this might be where the issue is. Custom code is enabled as per screenshot, however not allowing me to select to add this element in the cube. Notebook - Output data frame to be a selectable option in Cube Hi, I'm trying to load my enriched dataset from my notebook in the cube but can't find any documentation or guidance anywhere. Whereabouts can I surface SisenseHelper.save_dataframe(new_df) SolvedRe: Y Axis sorting Hi Benji, Thanks for the info, I've added in the scripts and tooltip is gone as requested, and sorting on the y axis has been achieved however, this has now re ordered the x axis. I've tried to incorporate another script I found but it's not working. Can you provide further assistance please? widget.on('beforeviewloaded',function(se,ev){ ev.options.chart.type='heatmap' }) var xOrder = 'desc' //also, this value can be desc var yOrder = 'asc' widget.on('beforeviewloaded', function(scope, args) { var shouldBeExecuted = (order === 'desc' || order === 'asc' ) if (args.widget.type !== 'chart/scatter' || !shouldBeExecuted) { return } var daysOrder = args.options.xAxis.categories.sort(); if (xOrder === 'desc') { daysOrder.reverse() } if (daysOrder.length === args.options.xAxis.categories.length) { args.options.xAxis.categories = daysOrder for (i=0; i<daysOrder.length; i++) { for (k=0; k<args.options.series.length; k++) { for (j=0; j<args.options.series[k].data.length; j++) { if (args.options.series[k].data[j].selectionData[0] === daysOrder[i]) { args.options.series[k].data[j].x = i; } } } } } }) widget.on('beforequery', function(se, ev) { ev.query.metadata.forEach(function(m) { if (m.wpanel && m.wpanel === 'y-axis') { m.jaql.sort = yOrder } }) }) var categories= ['00:00','01:00','02:00','03:00','04:00','05:00','06:00','07:00','08:00','09:00','10:00','11:00','12:00','13:00','14:00','15:00','16:00','17:00','18:00','19:00','20:00','21:00','22:00','23:00',]; widget.on('queryend',function(se,ev){ ev.rawResult.values.sort(function(a, b){ var aIndex = categories.indexOf(a[0].data.trim()); var bIndex = categories.indexOf(b[0].data.trim()); if (aIndex < bIndex) return -1; if (aIndex > bIndex) return 1; return 0; }) }) widget.on("beforedatapointtooltip", function (se, args){ args.cancel=true; }); Y Axis sorting Hi All, Can anyone help with sorting the Y axis on this scatter. I can see why it's building this way but I need it to be more readable for the end user. Additionally is there anyway to hide the empty tool tip or at least include value, X & Y Blox Sparkline hover label Hi, is it possible to configure the hover option on a Sparkline to include a date label? Pulse and exploration paths for Blox Widgets Hi all, I wondered if it is possible to enable pulse or exploration paths for a blox widget, there doesn't seem to be any information/documentation regarding this following a quick search. Ideally, I'm hoping there is a custom action that can trigger these as it would be more present on the dashboard. But just to have the functionality would be a big win. Thanks Re: Blox - Action button - Hover options Thank you Harry, worked a charm Blox - Action button - Hover options Hi All, A small thing, I hope you can help with. When changing the colour of an action button in Blox the hover settings disappear, i've scoured online to see how to write this back into the config but not had any luck. trying to go from blue to light blue on hover: { "type": "ActionSet", "actions": [ { "type": "Filters", "title": "Apply", "style": { "backgroundColor": "blue", "button:hover": { "backgroundColor": "#lightblue", "transition": "0.7s" }