question

hikel avatar image
0 Likes"
hikel asked hikel commented

How Can I get Aisle by number of slots graph or table

I am trying to get Aisle vs number of slots in each aisle which is the total. I manage to get the total number of slots so far. Dashboard racks.fsm

FlexSim 23.2.2
dashboardsprocesss flow
dashboard-racks.fsm (52.0 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

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered hikel commented

This will place the array in a global table:

Storage.system.querySlots("SELECT slot.aisleID, count(*) GROUP BY slot.aisleID",0).as(Array).as(Table).cloneTo(Table("GlobalTable1"))
· 3
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.

hikel avatar image hikel commented ·
Thank you @Jason Lightfoot just for the graph that I got in dashboard sometime shows total location sometimes no. Do you have any idea why is that?
0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦♦ hikel commented ·
No idea - for me it never shows the correct number
0 Likes 0 ·
hikel avatar image hikel Jason Lightfoot ♦♦ commented ·
got it Thank you
0 Likes 0 ·