question

jacopo-r avatar image
0 Likes"
jacopo-r asked jacopo-r commented

Grouping in calculated table

Hello,

I am trying to create a metric that counts the number of person per every group, using a calculated table.

1720604645865.png I didn't have any success so far. Can anyone help me out please?

My goal is to be able to show in a dashboard, using a table chart (or histogram), how many person per group.

Thanks!


CalculatedTable_Grouping.fsm

FlexSim 24.0.1
calculated table
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Lars Christian J2 avatar image
0 Likes"
Lars Christian J2 answered jacopo-r commented

An option is to go to Calculations and "Enable direct editing". There you can specify "COUNT(Person) in the SELECT statement and add "GROUP BY".


1720606022160.png

calculatedtable-grouping_1.fsm


· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

jacopo-r avatar image jacopo-r commented ·
0 Likes 0 ·