How to look up data in other table charts

[makoto]

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,

[abhijitnalekar · Accepted solution]

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.

[makoto]

Hi Abhijit,

Thank you for your answer.

It went well!

Regards,

Makoto