Hello, still working on a results binding after that awesome webinar last week. I'm trying to do a simple math from a result step from another dataset. The problem I suspect is that the step is from compare table lens with 7 columns and the one column I want "D" is a calculation already. So, do I used the Column function? And if so, what is the value that I use? Is it "D" from the Measure or the header from the Column.? Here is my query:
"query": {
"pigql": "q = load \"Comparison_Group_Data\";q = group q by all;q = foreach q generate {{column(Lookup__Customer_Gro_1.result,\"D\").asObject()}} - 1 as 'Diff';",
"measures": [
[
"Diff",
"*"
]
],
"measuresMap": {},
"groups": []
},
@Joseph Yelle Thank you so much!! It was those items that I was missing and now my dashboard is very dynamic!!
