Infotable Aggregate on multiple columns
Jun 17, 2020
03:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Jun 17, 2020
03:11 AM
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?
when i try with only one column, the above code works fine.
Thanks
Solved! Go to Solution.
Labels:
- Labels:
-
Best Practices
ACCEPTED SOLUTION
Accepted Solutions
Jun 17, 2020
04:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Jun 17, 2020
04:24 AM
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"
});
1 REPLY 1
Jun 17, 2020
04:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Jun 17, 2020
04:24 AM
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"
});
