Total Records In A Table

[jhanajc]

Hi all,

 

 

Is it easy to calculate the total number of records in a table to display on a data page?

 

I was thinking of creating a landing page with summary data on it including some record totals.

 

 

Thanks!

 

JC

[svitlanataran]

Hi, yes, it's very easy. 

 

You should add "Totals and aggregation" to your report. You can read more here

Also if you're interested in advance reporting you can find a video and articles here

[jhanajc]

Thank you!

[pilotexpressions]

Do these calculations require the paid version of Caspio? I've been looking all over for this in my tabular report and cannot find it anywhere!

 

Also, if so and need to upgrade, can I pass the calculated value into one of my datatables?

[Kurumi]

I think it is only available for paying accounts. You may check their pricing plan here:  https://www.caspio.com/pricing/standard-edition/ and try to find Formulas and Calculations. 

To your second question, yes you can pass your Calculated Value. You may set this as one of your fields in your table. 

 

I hope this helps!

[Aether]

If you use Calculated field or value in this case, than you can use this formula to display the total number of records in your table:

SELECT COUNT([@field:ID]) FROM tablename

Please change the field:ID to your actual unique-identifier field and the tablename to the actual table you wanted to get the total of records.

For more information about the formula function you can use in the calculation, check out this documentation:  

https://howto.caspio.com/function-reference/

I hope this helps

~WatashiwaJin~

[petatech]

The SQL COUNT() function returns the number of rows in a table satisfying the criteria specified in the WHERE clause. It sets the number of rows or non NULL column values. COUNT() returns 0 if there were no matching rows. The above syntax is the general SQL 2003 ANSI standard syntax.

[MayMusic]

Yes, you can create a details page based on the same table. Add calculated fields and use SQL syntax to create the dashboard. For instance:

SELECT COUNT(Record_ID) FROM table_Name

[Glitch]

While it is true that you can use SELECT Statements for this. I think it is also doable using Pivot tables, wherein you can easily select Value then use summarize values by Count. You can refer to this link.