Calculation

[jojodhewa]

How to create counting calculation for same data will be count as one. For example

1. A

2. B

3. C

4. A

5. D

6. A

Total result should be 4,not 6, bcause the A was same data,will be count as one data..

How is it be?

[Mathilda]

Hi Jojodhewa,

What type of the datapage do you have?

[jojodhewa]

Report

[jojodhewa]

11 minutes ago, Mathilda said:

Hi Jojodhewa,

What type of the datapage do you have?

Reports table

[Mathilda]

7 hours ago, jojodhewa said:

Reports table

You may try using the following SQL statement in the Aggregation field:

SELECT COUNT(DISTINCT Field_name) FROM table_name

Please replace Field_name with your name of the field and table_name with name of your table.

 

You may find more information about this query at: http://www.w3schools.com/sql/sql_func_count.asp

Also you can read more  about aggregation here

 

Hope it helps

[NailDyanC]

Hi,

Just an additional info, Formula and Calculations are now available on all paid plans (new plans).

You may check Caspio's pricing for more details.

Also, here are some video tutorials about Totals and Aggregation: 

 

 

 

[Kurumi]

Hi everyone! Just an update: Caspio has finally released a feature to show DISTINCT records on Reports (Tabular/List/Gallery).

It is available in R30 version: https://howto.caspio.com/release-notes/caspio-30-0/