topic Re: how to get count of a data in App Development

how to get count of a data

Sara_3 — Thu, 31 Mar 2022 14:59:17 GMT

Hi,

I am creating the sample data table here :

Code	Category	Key
112	A	001236
112	A	002589
112	A	002574
456	B	003698
456	B	007896
890	A	002365
890	A	005987
890	A	002365
342	B	001478

.i have 3 fields i want count of "key" of all code where "category" = A. I tried aggr function in expression but did not to get the expected answer.

my input is Code. for example: when I select code (112 ) it belongs to category A . so my expected answer is count of all key which has category A.

Expected result: A = count key = " 6 "

i have tried this expression but it gives me different answer.

Sum(Aggr(Count(Key),category)

Thanks!

Re: how to get count of a data

Mark_Winter — Thu, 31 Mar 2022 13:48:20 GMT

Hi Sara,

count({<category={'A'}>}key)

Re: how to get count of a data

Sara_3 — Thu, 31 Mar 2022 13:57:37 GMT

Hi , sorry i forgot to mention that my input is Code. for example: when I select code (112 ) it belongs to category A . so my expected answer is count of all key which has category A.

Re: how to get count of a data

Sara_3 — Thu, 31 Mar 2022 14:02:47 GMT

i tried this expression but it gives me different answer.

Sum(Aggr(Count(Key),category)

Re: how to get count of a data

Mark_Winter — Fri, 01 Apr 2022 10:35:37 GMT

Aggr({1}nodistinct Count(key),category)

Re: how to get count of a data

Sara_3 — Fri, 01 Apr 2022 13:01:08 GMT

Thanks Mark , but does not work . it gave me total count of all key.