Calculating number of missing entries when data is coming from 2 different associated tables.

[DakshP]

I have 2 tables - Table1 and Table2. 

Table1 -

ID | Name

12 | Rohan

132 | Swati

153 | Virendra

Table2 -

ID | Subjects

12 | Hindi

153 | English

I associated these tables using ID, and when presented the data in a vizlib table it appears as

ID | Name | Subjects

12 | Rohan | Hindi

132 | Swati | -

153 | Virendra | English

I want to create a chart that will display " Number of ID's where Subject is missing " - in this case : 1(id-132).

What should be the formula used?

[Or]

Count(ID) - Count(Subjects) is probably the easiest and cleanest way in this scenario, but you could also use something like

Count(If(isnull(Subjects),1))

[vchuprina]

Hi,

Also you can use something like this:

Count({-<Subjects = {*}>}ID)

Regards,

Vitalii