What I want to do:
I simply want to add an expression in Dynamic content of Text widget so that I can calculate proportion (see Figure below). However, it fails whenever I add using conditional sentences (==). I tried lots but nothing works.
I really appreciate your assistance.
Similarly, I created an expression to calculate population per square mile, and I want to use the ROUND function on the result. I think this would be an Arcade function but maybe Arcade is not available in Experience Builder?
Hi Eiji and Kevin,
Thanks for the question. The dynamic content does not support SQL conditions or Arcade functions for now. The expression only supports string binding and simple calculations currently (see dynamic content help) and other functions will be added gradually in further releases.
To display filtered results in Text, maybe you can apply filters to the data source used in the Text widget in two access:
Be aware that both filters are global and will affect every widget that consumes the same data source.
We are planning to support set filters within Text in the next release and you will be able to display info under certain conditions.