Skip to main content
VaibhavShinde16-Pearl
16-Pearl
Jun 17, 2020 7:11 AM UTC
Solved

Infotable Aggregate on multiple columns

Hi ,

I am trying aggregating multiple columns as shown below, i tried with putting comma separated columns but don't work. What is the solution?

VaibhavShinde_0-1592377741640.png

when i try with only one column, the above code works fine.

 

Thanks

CarlesCollAnswer
1-Visitor
Jun 17, 2020 8:24 AM UTC

You aren't using the right format, columns it's a comma separated list of values, and aggregates also:

 

var result = Resources["InfotableFunctions"].Aggregate({
 t: result1,
 columns: "ApparentPower,ConsumePower",
 aggregates: "SUM,SUM",
 groupByColumns: "Mkey" 
});
View in thread

1 reply

CarlesColl1-VisitorAnswer
1-Visitor
Jun 17, 2020 8:24 AM UTC

You aren't using the right format, columns it's a comma separated list of values, and aggregates also:

 

var result = Resources["InfotableFunctions"].Aggregate({
 t: result1,
 columns: "ApparentPower,ConsumePower",
 aggregates: "SUM,SUM",
 groupByColumns: "Mkey" 
});
Translate
    Terms & ConditionsAccessibility statement