How to use calculate table from statistic collector

[borja_lorenzo4278]

[ FlexSim 24.1.1 ]

Hello everyone
In the attached model, I want to be able to calculate the difference between the end time of the last task and the start time of the first task in a 'Calculated Table.' Ideally, I would like to use this value to display it in a table chart on the dashboard.
Could you help me configure it?"
Thank you in advance.

Simplificación Statistic Collector from List 250113.fsm

[moehlmann_fe · Accepted solution]

Assuming that the value in the last row will always the highest the query would just be

SELECT MAX(Tiempo_Final) - MIN(Tiempo_Inicial) AS EnterColumnNameHere FROM Tiempo_Produccion

(Enable direct editing on the "Calculations" tab of the Calculated Table to be able to enter this manually and set the Update Mode to "Always")

[borja_lorenzo4278]

Thanks a lot

It works like a charm
Adjunto el archivo resuelto.

Simplificación Statistic Collector from List 250113_1.fsm

[jason_lightfootVL7B4]

Another answer to a duplicate question here.

[borja_lorenzo4278]

My answer here: https://answers.flexsim.com/comments/175728/view.html