Grouping By Age

[KAPITYAN]

Can I use a chart or graph, pivot table etc to show the age by grouping it? Example 0-5 years, 20- 30 years etc.

Please, do you have an example?

[NailDyanC]

Hi @NJConrcs

Regarding with your test case, unfortunately your workflow is not yet available to the Standard feature of Caspio, as I know you can only just group it by Date using Charts and Graph.

But if you want to enable grouping by age, you can use Tabular DataPage to do that. And just make sure to create a formula field in your table and use a Case When Statement to get the range of the Age that you want (Ex. 1-5) , You can refer to this sample Case When Statement:

CASE
WHEN [@field:Age] = 1 OR [@field:Age] = 2 OR [@field:Age] =3 OR [@field:Age] =4 OR [@field:Age] = 5 then 'One to Five'
WHEN [@field:Age] = 6 OR [@field:Age] = 7 OR [@field:Age] = 8 OR [@field:Age] = 9 OR [@field:Age] = 10 then 'Six to Ten'
END

You can also refer to this link for a sample screenshot if you want this output using a Graph or Chart DataPage. However it is not grouped by Age instead it is just by Average of the Ranges of Age:

http://prntscr.com/l1wnul
http://prntscr.com/l1wo1h

 

Hope that helps.

[Glitch]

Just to add with the previous comment, you can make it shorter by putting:

CASE
WHEN [@field:AGE] >= 1 OR [@field:AGE] <= 5
THEN 'ONE TO FIVE'
WHEN [@field:AGE] >= 6 OR [@field:AGE] <= 10
THEN 'SIX TO TEN'
ELSE '0'
END

 

[NailDyanC]

On 1/25/2019 at 4:11 PM, NailDyanC said:

Hi @NJConrcs

Regarding with your test case, unfortunately your workflow is not yet available to the Standard feature of Caspio, as I know you can only just group it by Date using Charts and Graph.

But if you want to enable grouping by age, you can use Tabular DataPage to do that. And just make sure to create a formula field in your table and use a Case When Statement to get the range of the Age that you want (Ex. 1-5) , You can refer to this sample Case When Statement:

CASE
WHEN [@field:Age] = 1 OR [@field:Age] = 2 OR [@field:Age] =3 OR [@field:Age] =4 OR [@field:Age] = 5 then 'One to Five'
WHEN [@field:Age] = 6 OR [@field:Age] = 7 OR [@field:Age] = 8 OR [@field:Age] = 9 OR [@field:Age] = 10 then 'Six to Ten'
END

You can also refer to this link for a sample screenshot if you want this output using a Graph or Chart DataPage. However it is not grouped by Age instead it is just by Average of the Ranges of Age:

http://prntscr.com/l1wnul
http://prntscr.com/l1wo1h

 

Hope that helps.

Just want to add to this, you may also consider checking Caspio's Function Reference for other formulas: https://howto.caspio.com/function-reference/