Relocating /var/lib/docker directory
Docker uses /var/lib/docker to store images, containers, and local named volumes. Deleting this can result in data loss and possibly stop the engine from running. However in case if it is needed to free some space on the root volume, it is possible to relocate this directory to another partition or drive. This tutorial describes two ways on how to move the /var/lib/docker directory in Linux.36KViews0likes0Comments
PASTWEEK() & PASTYEAR() formulas in widget
Hello, I am having an issue creating a report looking at the week as defined by my dashboard filter versus the previous week as well as the equivalent week in the year before. Basically, I get my 'original' week very easily. We use Last week in the dashboad filter on the TransactionDate for it to report on the latest (most current) completed week. I saved that as a 'TW Units' which basically comes just down to 'sum([Quantity])', likely the easiest formular available in Sisense. Using the formula PASTWEEK(TW Units) I am getting the results for the previous week and they match what I pull via SQL from the raw data as well. In my mind I should just need to use PASTYEAR(TW Units) and should be getting the results from the preceding year for the week I am actually looking at. Instead I am getting returned the same results of the week I am looking at for the current year. Are those 2 formulas different somehow? There is noting in my elasticube that treats the dates any different.1.1KViews0likes0CommentsConcurrent users loggin
Hi everyone! Is there in Sisense a possibility to limit viewer logging in from one account, like a "concurrent" logging? So, if the user logs in with his username, then this username logs out of Sisense on all other devices where the login was previously performed.799Views0likes0Comments
Export to PDF Customise
Hello, I would like to know if there are any best practice on creating a dashboard which will give me a clean pdf export currently, my basic charts are distorted and divided into 4 separate pages blox widgets are of uneven sizes Widget titles are exported even though I have hidden them on the dashboard level I am not using any tabbers here if there is a script I can use to customize the export and make it look cleaner it would be very helpful thank you2.1KViews0likes2Comments
Pie Chart with Multiple Values
I have a very specific use case to build a pie chart with multiple value labels. A rough example is below, but essentially the use case is to have a pie chart show the % based off one value, but then display a second metric below that. Any thoughts or suggestions on how to pursue this? I know a stacked bar should bring a similar analytical value to the company, but for this use case, I can't get around the need for this formatting.1.7KViews0likes1CommentCustom Blox Filter for measure
Hello, I was wondering if there is a way to create a measure filter in my case customer spend filter, where the user can define a number and the views are filtered by it? so basically I want to filter my view for customers who spent more than XYZ number. I want to give my users the ability to input there number911Views0likes0Comments
Update Dashboard Date filter from selected Date to Last 365 days
Hi Team, We have requirement where we need to update dashboard date filter dynamically from selected date to Last 365 days from the date selected. We have a working code for windows, we are looking the same for Linux, attaching the windows code below, please help in fixing. var TABLE = "tablename"; var COLUMN = "columnname"; var COUNT = 365; var max = null; dashboard.on("widgetbeforequery", function(d, a) { var item = a.query.metadata.find(function(i) { return i.panel === "scope" && $$get(i, "jaql.table") === TABLE && $$get(i, "jaql.column") === COLUMN }); var title = $$get(item, "jaql.title"); //debugger; if (title == "Date") { var selopt, unselopt, selrng; try { selopt = $$get(item,"jaql.filter.members"); } catch (e) { } try { unselopt = $$get(item,"jaql.filter.filter.exclude.members"); } catch (e) { } try { selrng = item.jaql.filter.to; } catch(e) { } var fItems=[], dItems=[]; if(selopt) { for(i=0;i<selopt.length;i++) { fItems.push(moment(selopt[i]).toISOString().slice(0,10)); } } if(unselopt) { for(i=0;i<unselopt.length;i++) { dItems.push(moment(unselopt[i]).toISOString().slice(0,10)); } } if(dItems.length>0) { for(i=0; i<dItems.length; i++) { var fl = fItems.length; for(j=0;j<fI;j++) { if(fItem[j]==dItem[i]) { fItem.splice(j,1); --fl; } } } } if(fItems.length>0) { fItems = fItems.sort(function(a,b) {return moment(a) - moment(b);}); max = fItems[fItems.length-1]; } else if(selrng) { max = selrng; } } else { // replacing members with last/next delete item.jaql.filter.from; delete item.jaql.filter.members; item.jaql.filter.last = { offset: 0, count: 365, anchor: max }; } }); Thanks Naz948Views0likes0Comments
How to change my widget breakdown with a viewer license (could not go to edit setting) ?
Hello, Is there a way to change my widget breakdown with a viewer license (could not go to edit setting) ? I mean I have 1 widget broken down by Client Segment (see below) And I want to be able to switch "Client segment" into "Length of Rental segment" without going to edit setting of the widget and with a viewer license. Thanks for your help.4.4KViews0likes5CommentsConditional Tooltip based on Date granularity
Hello, I am very new to sisense and have a typical requirement so I am using blox buttons to change the granularity in a widget In the same widget I would like to show comparisons in tooltip for last month, last quarter depending on the granularity selected in this button or if there is a way I can just show comparison in another widget but like for tooltip it needs to change with the selected granularity hope this makes sense1.1KViews0likes0Comments
Relocating /var/lib/docker directory
Docker uses /var/lib/docker to store images, containers, and local named volumes. Deleting this can result in data loss and possibly stop the engine from running. However in case if it is needed to free some space on the root volume, it is possible to relocate this directory to another partition or drive. This tutorial describes two ways on how to move the /var/lib/docker directory in Linux.
