Grouping in calculated table

[jacopo_r]

[ FlexSim 24.0.1 ]

Hello,

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

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

[lars_jacobsen_ScandiSim · Accepted solution]

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".

calculatedtable-grouping_1.fsm

[jacopo_r]

Thanks @Lars Christian J2