• 0

Grouping By Age

Question

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?

Recommended Posts

• 0

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.

Share on other sites

• 0

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

Share on other sites

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

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/

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.