Hi
How can I count the records of a table and display it on the app screen?
Tks
Solved! Go to Solution.
Are there only 3 unique email addresses in the entire table?
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.
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
Are there only 3 unique email addresses in the entire table?
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
Technically speaking,
COUNT(UNIQUE(BASE[ACCOUNT]))
is equivalent.
ya got me!
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
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |