Aug 31 2018
05:25 PM
- last edited on
Apr 07 2022
05:27 PM
by
TechCommunityAP
Aug 31 2018
05:25 PM
- last edited on
Apr 07 2022
05:27 PM
by
TechCommunityAP
Take this example:
let T = datatable(x: int, group: string) [
23, "red",
44, "red",
55, "red",
66, "red",
11, "green",
43, "blue"
];
T | make-series avg(x) on x in range(0,100,20) by group
It works fine...
But if I want to use a variable to hold the range, it fails with syntax error...
let R = range(0,100,20);
let T = datatable(x: int, group: string) [
23, "red",
44, "red",
55, "red",
66, "red",
11, "green",
43, "blue"
];
T | make-series avg(x) on x in R by group
Is this expected behavior?
Sep 04 2018 11:12 PM
My understanding of the language that this is intentional. You cannot replace whole operators. You can this though:
let firstNum = 0; let secondNum = 100; let thirdNum = 20; let T = datatable(x: int, group: string) [ 23, "red", 44, "red", 55, "red", 66, "red", 11, "green", 43, "blue" ]; T | make-series avg(x) on x in range(firstNum,secondNum,thirdNum) by group