Count records

,

Hi

How can I count the records of a table and display it on the app screen?

Tks

4 Likes

I’m using the ‘detail’ view type

Is there a method to display the total number of records somewhere on the screen

You could add a Virtual Column to that Table, using the COUNT() expression from above, and show the new column in that Detail View.

3 Likes

I created the virtual column and used the expression COUNT (SELECT (BASE [EMAIL], TRUE, TRUE))

the answer was 3
but BASE has 1660 records

I think I’m still missing something :roll_eyes:

Are there only 3 unique email addresses in the entire table?

2 Likes

you’re right

I changed it to COUNT (SELECT (BASE [ACCOUNT], TRUE, TRUE)) and now I got the right result

tks

COUNT( BASE[ACCOUNT] )
is equivalent

1 Like

Technically speaking,

COUNT(UNIQUE(BASE[ACCOUNT]))

is equivalent. :slight_smile:

3 Likes

ya got me!

2 Likes

I use a slice to separate the records from the base [EMAIL] = USEREMAIL ()
how do I link this to COUNT (SELECT (BASE [ACCOUNT], TRUE, TRUE))

You specify Slices the same way you do Tables.

I did not understand

I want to count the user current records

how can I do this