Connections

[#1]

Hi everyone!

Could you, please, help to identify and fix the following problem?

Data structure is the following:

If I click on any value of var 'lemois' (CM and CMD tables), data in the AV and Q tables are recalculated and becomes a bit wrong. At the same time I need Q and CMD tables be connected and can't change it.

Could anyone, please, advice me, something!

Thank you in advance!

Marina

[pokassov]

Hello!

You can calculate expressions for tables Q and AV ignoring selected values in lemois.

for example

count({$<lemois=>} b10)

[#3]

Sergey, thanks muchly!!!

Marina

[#4]

Sergey,

could you, please, help me with the following problem.

I need to exclude the FIELD lemois (you've already hepled me with this) and estimate indicators only for the last month. The second condition is the following: avg({<month={"$(=max(month))"}>}FIELD).

The first one: avg({$<lemois =>}FIELD).

What operator I should use or how it should be scripted to work properly (both conditions at the same time)?

Many thanks in advance!

Marina

[pokassov]

Hello!

avg({<lemois =, month={"$(=max(month))"}>}FIELD).

[#6]

Sergey, great big thank you!