topic How to look up data in other table charts in App Development

How to look up data in other table charts

makoto — Wed, 27 Oct 2021 03:23:18 GMT

Hi there,

I have a table chart having some columns shown source data and a expression column as attached.
I would like to show the total number of the expression column in another place.
Is there any way to look up data in another table chart?

Regards,

Re: How to look up data in other table charts

abhijitnalekar — Wed, 27 Oct 2021 06:46:41 GMT

Hi @makoto ,

You can create a measure at script level or master measure at app level like below

sum(if(size<11,1,0)) as small
sum(if(size>11,1,0)) as big

I hope I have understood the requirement properly.

Re: How to look up data in other table charts

makoto — Wed, 27 Oct 2021 08:40:25 GMT

Hi Abhijit,

Thank you for your answer.

It went well!

Regards,

Makoto