topic Re: Field of expressions in App Development

Field of expressions

drewjamison1396 — Wed, 01 Sep 2021 16:04:46 GMT

I am trying to create a visualization(bar chart) that runs off of a field that's values are different expressions. Also I would like the filter pane to allow me to change which expression is being used.

Re: Field of expressions

salonicdk28 — Thu, 02 Sep 2021 12:55:10 GMT

Hi,

You need to add inline table in the script like

Load* Inline [
Metric
Margin
Cost
Sales
];

then add the below expression in the bar chart as

=If(Metric='Cost', Sum(Cost),if(Metric='Sales', sum(Amount),if(Metric='Margin', sum(Amount)- Sum(Cost)))

and place the formula in else condition if you want to show anything as default without selecting any filter

Re: Field of expressions

drewjamison1396 — Thu, 02 Sep 2021 21:45:26 GMT

Thank you for the help. I came across the solution of just having the expression $(=calculation)