Hello,
Is there a way to pass variables inside DATATABLE() ? Documentation says it's not but I still would like to see if someone came up with hack to do that.
here is the example. I would like to pass varaibles One, Two, Three as a second value in a row constructor inside DATATABLE( )
DEFINE VAR Three = 3 VAR Two = 2 VAR One = 1 VAR cars = DATATABLE( "Maker", STRING, "Sales", INTEGER, { { "Ford", 3 }, // I would like to pass variables from above { "Ford", Three } { "Jaguar", 2}, { "Jaguar", 1 } }) EVALUATE FILTER( cars, [Sales] >= 2 )
Thanks
Solved! Go to Solution.
An alternative could be
Table = VAR Three = 3 VAR Two = 2 VAR One = 1 VAR cars = { ("Ford", Three), ("Jaguar", 2),("Jaguar", 1 )} RETURN FILTER(cars,[Value2] >= 2)
An alternative could be
Table = VAR Three = 3 VAR Two = 2 VAR One = 1 VAR cars = { ("Ford", Three), ("Jaguar", 2),("Jaguar", 1 )} RETURN FILTER(cars,[Value2] >= 2)
User | Count |
---|---|
138 | |
84 | |
63 | |
60 | |
57 |
User | Count |
---|---|
211 | |
109 | |
89 | |
76 | |
74 |