Jump to content
  • 0

Grouping By Age



2 answers to this question

Recommended Posts

  • 0

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:

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'

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:



Hope that helps.

Link to comment
Share on other sites

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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...