Creating table on Dashboard showing time in State

[jamesriebau]

How do I create a table on a dashboard that show the amount of time spent in each state?  I only have the option to add a pie chart or bar chart by %.  I can click view table on the pie chart to see the information I want; but how do I show on the dashboard?  In this case I'd just want to show only the used states.

Thanks,

Jim

[moehlmann_fe · Accepted solution]

You can (sort of) show the actual times in the pie or bar state chart. If you uncheck the "Show Percentages" option FlexSim will display the actual time values when hovering over a bar/pie segment.

To get the values in a table, install the components of the chart to make the Statistics Collector accessible. Then you can use a Calculated Table to only select the states with a time > 0 and display its result on the dashboard.

[jamesriebau]

Thanks, this worked for me.  I was able to copy what you did in your sample and make it work in mine.

[ddtsk]

Hey @moehlmann_fe 
This model looks good for the above question can we get the data monthly hours of each state using calculated table? 

[moehlmann_fe]

Collecting data throughout the model is the job of Statistics Collectors. To get monthly data you need an event that triggers once at the start/end of every month, so that a Statistics Collector can react to it and store the time spent in each state during the last month.

The event is probably easiest to set up as a message loop on a dummy object or a timer in Process Flow. For the collector you can start out with the default state chart collector. You switch out the OnReset event for the message trigger and finish the created rows. In the Time column you calculate the difference between the current total state time and the value from the previous month, then store the current value for next month's execution of the code.