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
1720604645865.png (2.8 KiB)
calculatedtable-grouping.fsm (83.3 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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 Jacobsen avatar image
0 Likes"
Lars Jacobsen 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


1720606022160.png (18.9 KiB)
calculatedtable-grouping-1.fsm (32.1 KiB)
· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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 ·
Thanks @Lars Christian J2
0 Likes 0 ·