Applied JAQL formula on top of another JAQL formula result | Help and How-To

enmiwong · 2024-08-23T09:18:36.243000Z

Hi,I have applied a JAQL formula to get new values (the values * 10), after that, I want to get the MAX from the result of the first query. how to achieve that?this is the result get from JAQL : [{"data": 4.3,"text": "4.3"}, {"data": 1,"text": "1"}, {"data": 43,"text": "43"}]the third column is get by applied this JAQL formula: {"jaql": {"context": {"[sepal_length]": {"dim": "[irisdataset6.sepal_length]"}},"formula": "10 * MAX([sepal_length]) + 0","title": "transform_x"}}now I want to get the max from the third column, how to achieve that?

MoreDiscussions

Applied JAQL formula on top of another JAQL formula result | Help and How-To | Sisense Community