Grouping in calculated table

Question

question

jacopo-r asked Jul 10, '24 jacopo-r commented Jul 10, '24

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!

Software Version:

FlexSim 24.0.1

calculated table

1720604645865.png (2.8 KiB)

calculatedtable-grouping.fsm (83.3 KiB)

5 |100000

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

Answer 1 · 2024-07-10T10:09:13Z

Lars Jacobsen answered Jul 10, '24 jacopo-r commented Jul 10, '24

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 (18.9 KiB)

calculatedtable-grouping-1.fsm (32.1 KiB)

· 1

5 |100000

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

jacopo-r commented · Jul 10 at 10:35 AM

Thanks @Lars Christian J2

0 ·