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.11
