Counting Only From the Right Table

[christian77]

Hi people:

I have a problem.

I´m trying to count item_id. This field appears in two tables. When I count, it counts from both tables. I wanna count only from one of them.

How can I do that.

Please help me.

I´m posting example.

Thanks in advance.

[spividori]

Hi.

In the script add:

left join(Items)
load Item_id,
Item_id as ItemCount
resident Items;

and then count ItemCount.

I hope help you.

Regards.

[#3]

Hello,

You may try this, Join the Peso field to the Items table and store it in Items and then drop the table OtraTabla: This way you will drop the field Item_ID from Otra Tabla, but retain the Peso data within Item Table.

Mama

[#4]

Hi,

Try this:

count({$<~Peso={'*'}>} distinct Item_id)

Hope this helps

Regards!

[matt_crowther]

I might be missing something totally obvious here but the below in a text object works for me:

=count(if(len(Color)>1, Item_id))

It works when selections are made and selection aren't??

Hope that helps,

Matt - Visual Analytics Ltd