Script reading/using a subset of whole Table Widget
Hey all, I'm running into an issue with my current task: I'm trying to add a column to a table widget containing values calculated using values provided in the table itself using 'edit code.' The final product would have a column that indicates whether that row is the maximum value compared to similar rows with different dates. IE, if I had to sort City, Store and Department for a company by revenue numbers by date, which date has the maximum revenue value by those aggregates, basically. To do this, I'm looping through the dataset, and trying to compare each value to a stored temporary max value. The issue arises here, looping through the data. When I log to the console the sites, or the dataset itself, the console shows 220 values, but the dataset has around 7800 rows, which should be what the console reports, no? I know this is an issue, because when I attempt to grab unique sites from the set, it returns only 22 sites, but I know there are roughly 38 or so unique sites in the set. widget.on('ready', function(sender,event) { setTimeout(function() { var queryResult = sender.rawQueryResult; var dataSet = queryResult.values; var dates = []; var sites = []; var weights = []; $.each(dataSet, function() { var date = this[0].text; var site = this[1].text; var weight = this[2].data; dates.push(date); if (!sites.includes(site)) { sites.push(site); } else {} ; weights.push(weight); }); console.log(sites); console.log(queryResult); console.log(dataSet); }, 500) }); I tried adding this timeout function to give the set time to load but it didn't seem to change anything. Also, I get the "Uncaught TypeError: Cannot read properties of null (reading'values') at eval" error, pointing to that line which reads the queryResults values, so I'm wondering if this error occurs at that 221st row and prevents the script from reading anything further, hence why I am receiving only 220 rows from the set rather than the whole set Anything helps, thanks Table widget, not Pivot Sisense version 2023.11Solved2.1KViews0likes4CommentsSSH show online users
In the SSH CLI, can I see who's currently online on the Sisense website? I want to reboot my server, but first I want to check no one is online. Normally I do this through the Admin page. But that's broken at the moment (that's why I want to reboot).Solved1.3KViews0likes4Comments
Linux Install Errors when /opt and /opt/sisense are both separate filesystems
I have found a bug in the Linux installer when both /opt and /opt/sisense are separate filesystems. The installer will give an error like ""Sisense /opt minimum requierment disk size: 50GB", even if the /opt/sisense directory is greater than the minimum size. This check happens in the file "installer/02_sisense_validations/remote.sh", in the "validate_opt_disk_configuration()" function. If the /opt filesystem exists, the code does not also check for /opt/sisense. This can easily be worked around by having the code check for /opt/sisense first, and for /opt second if the first is not found, then the code will continue to work as expected.Solved520Views0likes1Comment