Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts!
I have a problem with the expression editor of some charts. The code is the following:
Count ({<Field1={'>=$(VAR1)'}>} {<Field2={'$(VAR2)'}>} Measure)
The problem is that the chart changes depending ONLY on the changes of the second vaiable mentioned in the script (here, VAR2). If i switch the variables in the expression, it changes again with the second one (in this case VAR1). Therefore there should be an error in the code, I want it changing depending on the 2 variables.
Could anyone help me?
Thank you very much!
Hello Andrea,
Trust that you are doing well!
Please refer given sample expression:
Count ({<Field1={">=$(VAR1)"}, Field2={"=$(VAR2)"}>} Measure)
Hope this will be helpful.
Regards!
Rahul
Your syntax for combining two conditions is incorrect - you can only have a one set filter in an expression. But the set filter can be as complex as required:
Count({<Field1 = {">=$(VAR1)"}, Field2 = {"$(VAR2)"}>} Measure)
It would be helpful to explain how VAR1 and VAR2 are defined, as this might affect the correct syntax.