Evaluating background color expression in pivot table

sebastian_serva — Fri, 17 Feb 2017 07:38:43 GMT

Hi all,

I'm using the Capabilities API to get the model of a pivot table and build a custom JS table:

app.getObject('domID', objID).then(function(model){

// Parse model and build custom table

});

The pivot table has 3 measures and each measure has a background color expression.

I noticed that this expressions come through in the measureInfo object, under qAttrExpression. The issue is that the expression comes through as it appears in Sense:

qFallbackTitle = "if(value > 20, green(), red())"

What's the best way to evaluate this expression and get a color value as a result that I can use in my custom table?

Thanks,

Seb.

topic Evaluating background color expression in pivot table in Integration, Extension & APIs

Evaluating background color expression in pivot table