topic Re: count records which has common id in both tables in App Development

count records which has common id in both tables

deeavhad — Tue, 03 May 2022 13:46:01 GMT

Hi, I have 2 tables and both has 'Profile id' as common field , now In Table1 I need to do a vlookup with T2 to look for exactly same 'profile id' and need to take count of matching 'profile id' for specific month.

I need expression for above condition, please help

Re: count records which has common id in both tables

rwunderlich — Tue, 03 May 2022 14:17:45 GMT

Is this in the script or in a chart?

-Rob

Re: count records which has common id in both tables

deeavhad — Tue, 03 May 2022 14:21:41 GMT

I don't understand where to apply, I think 1st need to do something in script and then in chart

Re: count records which has common id in both tables

rwunderlich — Wed, 04 May 2022 13:27:35 GMT

In a chart, the two tables will be automatically linked ("associated") by the common field. So you can just count any field in table two. eg

Count(somefield)

If you have further questions can you post a screenshot from the data model viewer or some sample data?

-Rob