Show Total Number of Records from a Query

We created a page, which returns records from a database query. We want to show the total number of records in a paragraph below the table:

Double click inside the paragraph, to activate the edit mode. Then click the dynamic data icon:

In the data picker, select your database query(1) and click the data formatter icon(2):

Right click the expression and then select the count formatting option, in the collections category:

Click Select:

And click Select to insert the formatted value on the page:

Then save:

And you are done, the total number of records is displayed on the page: